Excel Formula help (Check if a time falls between to time arguments)

H

Healingbear

If A1=1:00 PM
and B1=9:00 PM

I'm looking for a formula that will check to see if, say, 6:00 PM fall
within the range, which would show me it's an evening staff, as oppose
to 6a - 2p which should be FALSE as it's a morning staff.

Thanks in advance for any and all assistance.

Healingbea
 
T

Trevor Shuttleworth

Healingbear

This maybe:

=IF(AND(C1>=A1,C1<=B1),"in range","not in range")

Regards

Trevor
 
Top