With the Sign-in time in B13, Sign-out time in B14 and the Test time in B15
try:

=IF(OR(B15=B13,B15<=B14),"Yes","No")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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?