Excel 2007 : If statement using Time Intervals

I am trying to create a file that will tell me yes or no if a time falls between a certain period, for example, 5:00 and 13:00.
I tried to use =IF(TIME(0,0,0)<F4<TIME(5,0,0),"Yes","No").
This works if you are just trying to say greater or less then, but doesn't seem to work with both.

Please help!!!

You need to do it like this:

=IF(AND(TIME(0,0,0)<F4,F4<TIME(5,0,0)),"Yes","No")

though you might need to change one of the < to <=

Hope this helps.

Pete