Hi Seanie,
Assuming you have the current time in cell A1, write 7:00:00 PM in B1 and
11:59:59 PM in B2. After entering, both of them will appear as
19:00
23:59, respectively,
Now apply the following formula.
=IF(AND(A1B1,A1<B2),"Yes","No")
Hope it helps.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
New Delhi, India
"Seanie" wrote:
How could I construct a formula that checks if the Current Time is
Greater than 7:00pm and Less than 12:00am