Assuming that the daily hours are in F10:F16, and the the regular hours
are in G10:G16, then use
=MIN(F10,10)
in G10,
=IF(SUM(G$10:G10,MIN(F11,10))40,40-SUM(G$10:G10),MIN(F11,10))
in G11, and copy G11 and paste over G12:G16. Then get overtime hours by
subtraction.

Jerry

TeeJay wrote:

To simplify using my timesheet I am trying to use multiple functions so all
that I need to do is enter the start and finish times and it will
automatically fill in my standard and overtime rates.

I currently have the formula =IF(F10<=10,F10,10) in my standard rate column
where F10 is my hours worked that day. My overtime column has the formula
=IF(F1010,F10-10,"") and this works to tell me any overtime on a day to day
basis and keeps the sheet fairly clean.
However as well as going into overtime if I work more than 10 hours day, I
also go into overtime if I work more than 40 hours in a week so ...

I want to add an additional argument where if the sum of a column becomes
greater than 40, the additional moves into the next column. For example if I
had four 8s and then a 10, the ten would be split into an 8 which would
remain in the column and a 2 would be transferred to the overtime column in
the cell for that day
It would be nice also if the column once the column total reached 40, any
further days would go blank.
Please note that days worked and hours per day can vary week to week so
values need to based on the F10 figure or the overtime limits.

I'm guessing that I'm headed towards circular functions with this and any
help would be appreciated