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.