You're right, Buddy. If A1 = 12:15 AM AND B1 = 11:30 PM...I would need C1 to
be "Late By 45 mins" and instead it's "Early by 23:15"

Shift would be 8 PM - 8 AM

"Billy Liddel" wrote:

The trouble is that although they may be on the same shift, they are not on
the same day. 12:15 AM is just 15 minutes and this is lower than 22:00 (10:00
pm)

If 00:15 is in A1 this is lower than 22:00 just as 21:30 (9:39 PM)

By the way, what times does the shift cover? I do not know if this makes any
difference.