If And conditions for Time

texascpa · #1 11-22-2017, 09:10 AM

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

Similar Threads
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
3 Conditions	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