Oh yeah In my formula I had to change 40 to 80 as I get paid every two weeks, but that is where the more intriguing question I was talking about. Which is that everything over 40 hours is overtime still for 1 week so for example I could work 43 hours 1 week and only 32 hours the next which totals 75 hours, In my formula right now it will calculate that as all straight time since the 2 week total is not more then 80 but in reality I would be paid for 3 hours overtime. I dont know how to add that equation in the formula.

clo312