Payroll - Deduct one amount (overtime) from one or more totals

[ThirtyTwo]

On each line (Monday to Sunday) it calculates total work hours
It deducts breaks, which are fixed depending on duty duration
Depending on start times and end times it determines what the pay rate should be
All is good so far

When total hours worked > 36.25, then all hours above this are paid at a new rate

To allocate hours worked above 36.25 it has to remove the hours from the highest rate for that week, if the highest rate doesn't have enough hours to remove, then this is where I have a problem

It needs to remove what it can from highest pay rate, then work it's way down until all overtime hours have been removed

For example, in the attached file there are 13 hours to remove (G34)
It should take 8 hours away from Overtime 4 (G33)
Then take away 5 hours from Overtime 3 (G32)

In the adjusted section, it should also re-rank, to remove overtime details that have been wiped out during the above calculation, e.g. As all hours from Overtime 4 were removed, then there is now Overtime 3

Sounds messy, but viewing the file will make things clear

[ThirtyTwo]

I've updated the file to show new adjusted results

However, although some tests were successful, it doesn't always work

There are now a few helper columns to work out which rows get hours deducted as they've been re-allocated to the highest overtime rate

In the example attached I think the problem is in the helper columns

Standard = 20
Overtime 1 = 15
Overtime 2 = 9.75
Overtime 3 = 6.75
Total = 51.5
Total Standard = 36.25
Total Overtime = 15.25

Adjusted Results should be
Standard = 20
Overtime 1 = 15
Overtime 2 = 1.25
Overtime 3 = 15.25

From what I see, the problem is on row 33, the adjusted units should be the original value which is 15, but it's showing 7.75