How are your times stored in Excel?

Assuming original shift start/end are columns A & B, with OT start/end in
B&D then for EXTENDED shifts:

new Shift start =MIN(A2,C2)
new Shift end=MAX(B2,D2)

However, I don't know how you represent the reduced shift i.e take back
hours. To use the above formula, and with your example, the OT end time would
be 18:00 (and make OT start time the same i.e. 1800 ?)

HTH

"BBert" wrote:

I'm trying to create a new shifttime based on the original shifttime and
some overtime hours.
Let's say somebody works from 07:00 - 15:30 and is doing overtime from
15:30 - 16:30.
The new created shifttime should be displayed as 07:00 - 16:30.
Another example:
Original shift 14:00 - 22:00, overtime 12:00 - 14:00. New created
shifttime should be displayed as 12:00 - 22:00.

A similar question is when you take back some hours from the original
shifttime. For example, original shift 12:00 - 20:00, take back 18:00 -
20:00, new created shifttime should be displayed as 12:00 - 18:00.

Is there a function to accomplish that?

with kind regards,
Bert