IF Function Formula Based On Time.

**artiststevens** · 12-15-2010, 03:45 AM

Hello,
I need to create an IF function formula that the end result is TRUE if the time is between and includes 22:00 and 09:00. I've attempted this myself but I can't get it to work.

Example:

A1:is 23:00 B1:states A1 is TRUE based on the time

A2:is 13:00 B2:states A2 is FALSE based on the time

Thanks in advance for any and all help.

**jj72uk** · 12-15-2010, 04:08 AM

Maybe this will help?

=IF(AND(A5<=TIME(22,0,0),A5>=TIME(9,0,0)),"TRUE","FALSE")

**artiststevens** · 12-15-2010, 04:23 AM

Hey jj72uk,
Thanks for the help. I don't know if it's because Excel doesn't recognize negative time or what but I get FALSE for all times except 22:00 and 9:00. All numbers in between are FALSE. Do you have any other suggestions?