Okay guys, I've been doing a lot of searching the last couple of days and have made some progress but I'm still getting a little stuck.

I'm looking to calculate hours for weekly payroll.

I got the day to day measurements down but this is what I'm having trouble with:

I need a formula in column "C" to calculate the hours for row 6-8. I need it to calculate regular hours only if rows 2-6 are less than 40. Anything more than 40 should be calculated in the OT section.

Also, for the 7th day, anything worked more than 8 hours should be calculated as DT instead of OT.

I tried to add notes to the spreadsheet to make it easier to explain. Let me know

Payroll Hours.xlsx