Greater than AND Less than Time Q
12:00am meaning midnight?
Try this:
=IF(TIME(A1)19/24,"yes","no")
No need to test for the other condition.
But, if you were interested in, say, times greater than 7:00pm and
times less than 10:00pm, then you would have this:
=IF(AND(TIME(A1)19/24,TIME(A1)<22/24),"yes","no")
Note the use of the 24-hour clock.
Hope this helps.
Pete
On Mar 9, 8:52*am, Seanie wrote:
How could I construct a formula that checks if the Current Time is
Greater than 7:00pm and Less than 12:00am
|