Check if cell is in time interval

Hello forum,

I have 5 columns with time values, let say A1 is the actual time visited and B1,C1 is the first time interval and D1, E1 is the second time interval. I need to check if A1 falls into one of these time intervals. If it does than "TRUE" or else "FALSE". Time intervals can be very different from one to another, an example

A1 07:12
B1 07:00
C1 12:00
D1 13:00
E1 16:00

Then cell F1 will be "TRUE"

A1 16:05
B1 07:00
C1 12:00
D1 13:00
E1 16:00

Then cell F1 will be "FALSE"

Possible?
Regards
Soren

This maybe (unless you want VBA):

=IF(OR(AND(A1>=B1,A1<=C1),AND(A1>=D1,A1<=E1)),TRUE,FALSE)

If you are holding out for a VBA solution, then don't mark the thread as solved!