=IF(OR(AND($A$1<=$A$2,$A3=$A$1,$A$2=$A3),AND($A$ 1=$A$2,OR($A3=$A$1,$A1=$A$4))),"Yes","No")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"kmariab" wrote in message
...
i have employees sign-in and sign-out using military time. I want to be
able
to calculate if each employee was present at a certain hour. For example:
Sign-in: 8:00
Sign-out: 14:00
Was employee present at 9:00? Yes
Was employee present at 13:00? No

My problem arises when employee works overnight. For example:
Sign-in: 18:00
Sign-out: 3:00

Is there a formula that recognizes whether employee was present between
those times?