![]() |
#1
|
|||
|
|||
![]() Column A = time formatted in military time : 9:50 Column B= “Include” if time is between 7:59 (i.e., 7:59AM and 17:59 (i.e., 5:59 PM). If outside those parameters, “” in Column B. This is my formula: =IF(AND(A511>TIMEVALUE("7:59:00"),A511<TIMEVALUE(" 17:59:00")),"Include","") The return value in Column B is “” when the time is within the parameters. The return value should be “Include”. Need help with the formula |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sum with conditions | xling | Excel | 2 | 08-15-2017 12:16 AM |
Sumif with Conditions | Haha88 | Excel | 2 | 12-21-2016 12:08 AM |
6 conditions formula | paconovellino | Excel | 2 | 03-05-2012 06:45 AM |
![]() |
Laurie B. | Excel | 4 | 08-15-2011 10:27 PM |
how to set an equation with three conditions? | Jamal NUMAN | Word | 0 | 07-09-2011 06:05 AM |