Forum Discussion
Overlaping of worktimes
A B C D E F Start of overtime End of overtime Total overtime Start of Stand-by End of Stand-by Total Standby 0:00 1:30 2 7:00 19:00 12 7:00 20:00 13 7:00 19:00 0 ...
In F2:
=(E2-D2+(E2<D2))*24-ROUNDUP(MAX(MIN(B2+(B2<A2), E2+(E2<D2))-MAX(A2, D2), 0)*24, 0)
If you use comma as decimal separator, use semicolon ; instead of comma in the formula.
Apply General number format to F2, then fill down.