View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DILipandey DILipandey is offline
external usenet poster
 
Posts: 70
Default Greater than AND Less than Time Q

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