Hour Calculation Help!!!!!!

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

I think what I'm trying to see if there's a way to get a MIN and MAX calculation in the same cell.

Help anyone?

Sorry I didn't know that rule.

The only problem I'm still having is where if in one of the days the person works less than 7 hours, it deducts from the total ot instead of staying at 0.

Sorry that problem has been solved, what I'm getting stuck on is having that same column stop at 4. So the lowest number that it goes 0 and the highest be 4 (since after 12 work hours it would be Double Time).

Originally Posted by newdoverman

Rather than getting into complicated formulae based on days of the week (there is no indication that the Day 1 to Day 7 run from Sunday to Saturday or where in the week the numbering starts) that could be copied down the length of the columns I broke the system into three logical sections according to the rules that you indicate then applied separate formulae to each section.

I kept it simple.

Thanks a lot!

Thats exactly what I needed, the only thing was that on the 6th day it was supposed tobe OT if more than 40 instead of DT but I was able to fix that thanks to your original formula.