View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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