Timesheet Calculations to calculate overtime

I havea timesheet where there are 7 columns, one for each day of the week. I have a total column for all hours entered in the 7 columns. I have a column entitled Overtime and in this column I want to calculate the total hours of overtime for the week. If the overtime exceeds 8 hours then I want this column to stop at 8 and any left over wuld be entered in the next column entitled double time. I have tried an IF formula stating that if the total for the week exceeds 40 then the difference would be entered in the overtime column. However this then puts the total difference in that column.

M T W Th Fr
10 10 10 10 10

In this case what would be my formula for the Overtime column.

You can use the two equations below in the two columns to the right of your total hours calculation. Assumes total hours are in Column H. So first equation goes in I2 and second in J2.

Formula:

Please Login or Register  to view this content.

You can use the two equations below in the two columns to the right of your total hours calculation. Assumes total hours are in Column H. So first equation goes in I2 and second in J2.

Formula:

Please Login or Register  to view this content.