Hi All, I need formula to update column C, value if the time is between 7:00 AM to 9:00 PM "YES" else "NO" Find attached for the same.
Column A Column B Column C Date Time (MST) 7:00 AM 9:00 PM 3/28/2011 6:26 AM YES IF LESS THAN 7:00:00 AM THEN YES 3/28/2011 6:47 AM YES IF GREATER THAN 9:00:00 PM THEN YES 3/28/2011 6:51 AM YES Between 7:00 Am to 9:00 Pm, Cell value "NO" 3/28/2011 6:59 AM YES 3/28/2011 7:13 AM NO 3/28/2011 7:32 AM NO 3/28/2011 7:45 AM NO 3/28/2011 7:46 AM NO 3/28/2011 1:29 PM NO 3/28/2011 1:42 PM NO 3/28/2011 1:42 PM NO 3/28/2011 1:42 PM NO 3/28/2011 1:43 PM NO 3/28/2011 1:43 PM NO 3/28/2011 1:49 PM NO 3/28/2011 1:56 PM NO 3/28/2011 2:06 PM NO 3/28/2011 2:08 PM NO 3/28/2011 2:12 PM NO 3/28/2011 2:18 PM NO 3/28/2011 2:23 PM NO 3/28/2011 2:32 PM NO 3/28/2011 2:35 PM NO 3/28/2011 2:37 PM NO 3/28/2011 2:41 PM NO 3/28/2011 2:46 PM NO 3/28/2011 2:50 PM NO 3/28/2011 2:50 PM NO 3/28/2011 2:55 PM NO 3/28/2011 3:02 PM NO 3/28/2011 3:02 PM NO 3/28/2011 3:15 PM NO 3/28/2011 3:18 PM NO 3/28/2011 3:21 PM NO 3/28/2011 3:30 PM NO 3/28/2011 3:31 PM NO 3/28/2011 3:33 PM NO 3/28/2011 3:39 PM NO 3/28/2011 3:43 PM NO 3/28/2011 3:59 PM NO 3/28/2011 4:00 PM NO 3/28/2011 4:03 PM NO 3/28/2011 4:05 PM NO 3/28/2011 4:07 PM NO 3/28/2011 4:20 PM NO 3/28/2011 4:28 PM NO 3/28/2011 4:28 PM NO 3/28/2011 4:28 PM NO 3/28/2011 4:38 PM NO 3/28/2011 4:39 PM NO 3/28/2011 4:45 PM NO 3/28/2011 4:46 PM NO 3/28/2011 4:48 PM NO 3/28/2011 4:49 PM NO 3/28/2011 4:49 PM NO 3/28/2011 4:49 PM NO 3/28/2011 4:51 PM NO 3/28/2011 4:52 PM NO 3/28/2011 4:54 PM NO 3/28/2011 5:05 PM NO 3/28/2011 5:31 PM NO 3/28/2011 5:49 PM NO 3/28/2011 5:58 PM NO 3/28/2011 6:04 PM NO 3/28/2011 6:10 PM NO 3/28/2011 6:16 PM NO 3/28/2011 6:26 PM NO 3/28/2011 6:27 PM NO 3/28/2011 6:28 PM NO 3/28/2011 6:44 PM NO 3/28/2011 6:57 PM NO 3/28/2011 7:03 PM NO 3/28/2011 7:10 PM NO 3/28/2011 7:15 PM NO 3/28/2011 7:18 PM NO 3/28/2011 7:18 PM NO 3/28/2011 7:20 PM NO 3/28/2011 7:26 PM NO 3/28/2011 7:34 PM NO 3/28/2011 7:35 PM NO 3/28/2011 7:39 PM NO 3/28/2011 7:44 PM NO 3/28/2011 8:06 PM NO 3/28/2011 8:12 PM NO 3/28/2011 8:20 PM NO 3/28/2011 8:22 PM NO 3/28/2011 8:23 PM NO 3/28/2011 8:23 PM NO 3/28/2011 8:24 PM NO 3/28/2011 8:28 PM NO 3/28/2011 8:37 PM NO 3/28/2011 8:43 PM NO 3/28/2011 8:53 PM NO 3/28/2011 8:57 PM NO 3/28/2011 9:02 PM YES 3/28/2011 9:05 PM YES 3/28/2011 9:16 PM YES 3/28/2011 9:24 PM YES 3/28/2011 9:29 PM YES 3/28/2011 9:40 PM YES 3/28/2011 10:02 PM YES 3/28/2011 10:02 PM YES 3/28/2011 10:23 PM YES Thanks, Mayur -- Sent by http://webuzz.im/mail/ web mail client -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
