Hello! I am in need of help on a formula i uploaded my spreadsheet to show what i need. I need formulas for the REG, Drive, & OT columns to show the values of reg hours + drive hours over 40 = all OT hours

OR is there an overall simpler way to do this?

Attached Files

OT CALCULATION 2.xlsx (55.6 KB, 8 views)

im using Office 2016

This method gives you cumulative OT for each day

Attached Files

OT CALCULATION 2.xlsx (56.2 KB, 15 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Unfortunatly the file is corrupt so it will not let me view it.

I reattached the file
If it still does not work enter =MAX((SUM($E$5:E5)-40),0) in M5 and pull down
Also change M12 to =M11

Attached Files

OT CALCULATION 2.xlsx (60.3 KB, 9 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

that did work, however is there a formula that i could use in k5 to k11 and L5 to L11 to show total of regular hours + drive hours up to 40. to show the values that i manually entered into those columns?

Like this?

Attached Files

OT CALCULATION 2.xlsx (56.3 KB, 8 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post