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

  • Thread starter Thread starter Healingbear
  • Start date Start date
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
 
Healingbear

This maybe:

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

Regards

Trevor
 
Back
Top