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...
cristacan This formula will show TRUE if the time value is between 8 am and 5 pm and FALSE if it is not. You don't need an IF statement to return TRUE or FALSE.
=AND(MOD(A1,1)>=TIME(8,0,0),MOD(A1,1)<=TIME(17,0,0))
The format of the cell with the time value is not relevant.