Hi, Is there a formula that can identify as late someone that is supposed to start at 11:00 pm, but instead starts at 12:00 am. I have used many formulas and I can't seem to find one that works for time that passes the 12:00 am. The formulas just give me an early by 22 hours instead of late by 1 hr. What I am trying to do (if at all possible) is.... I have the Appointment Time, the arrival time and the Departure time. The emp that waits for more than 2 hours at his destination gets paid for the time (above the 2 hrs) but if the employee is late at his destination for more than 1/2 hr, he doesn't get paid for any wait time, if he is early, he get paid for any time above the 2 hours from the appointment time (not the arrival). All time must be calculated in .25 increments. Here is my sheet with some of the formulas I used.
46.7 KB Views: 1