Hi FDibbins! thank you for your quick response!

I entered the formulas into my spreadsheet, it works, but, once the times 06:00 to 12:00 are added in, then the normal time shows 5 and the OT shows 6. However, the OT should only show 1 and the rest should be under the normal time..

Same goes for 06:00 to 20:00, the "OT" time should only be 2, yet it shows 7, and the normal time is reduced to zero..


hope you can fix it! :D