Forum Discussion
IF Function help!
Trying to find a function that will work for the following: If the hour of the day is from 8am to 5pm, then false If the hour of the day is 5pm to 8am, then true. My data is formatted in hours wi...
This formula returns TRUE, if the time in A1 is before 8:00 AM or after 5:00 PM; otherwise, it returns FALSE:
=OR(A1<TIME(8,0,0),
A1>TIME(17,0,0))
=OR(A1<TIME(8,0,0),
A1>TIME(17,0,0))