I believe you will need to supply dates for all times involved other
wise you have a problem covering the 2 day shifts.

kmariab wrote:

Sorry, I had meant to type in: was the employee present at 15:00?, and the
answer to be NO.

"Bob I" wrote:


I see a problem already as both instances should be Yes. Also you would
need the date as part of the sheet.

kmariab wrote:


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?