Timesheet calculator to prevent sum to be over 40, and have the extra roll into OT

We have a punch in/out system that records exact time and then a payroll system that rounds that exact time. (stupid IMO, but see attachment for visual)

Say you work this below. Second set of times is just rounding the first to make it easier to know what to input (it also allows my employees to keep track of what they actually worked vs paid for) Anyways, the regular hours has to cap at 40, so if you round up then the 7.4 should really end up being a 7.3 because once you input, you hit 40 hours at 7.3.



True Hours - 8.17 8.07 8.23 8.15 7.38 -
True OT - - - - - 0.62 -


6130-001 Regular - 8.2 8.1 8.2 8.2 7.4 -
6130-001 OT - - - - - 0.6 -


Sorry, I i know that wasn't real clear. Hoping the attachment makes more sense. Actual hours are then rounded to nearest .1 and anything over 40 is rolled into OT.