here is the formula =IF(B2<=(7/24),"Yes",IF(B2>=(21/24),"Yes","No"))
On Wed, Mar 30, 2011 at 5:23 PM, <zinknax.zin...@gmail.com> wrote: > 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 > -- Your's Surendra -- ---------------------------------------------------------------------------------- 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
