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(F10>10,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