formulas using time

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I am trying to return results based on the time of day
entered into a cell.

here is an example of where I am at now.

=IF(AND(7:00AM>C1,C1<7:00PM),"DAYS","NIGHTS"

Please help
 
One way

=IF(AND(C1>"7:00 AM"+0,C1<"7:00 PM"+0),"DAYS","NIGHTS")

or if 7 should be included

=IF(AND(C1>="7:00 AM"+0,C1<="7:00 PM"+0),"DAYS","NIGHTS")
 
Back
Top