Well, I thought I got that right. Let's see: If D3=8 and D5=35, then that should be 35 hrs * 8 $/hr = $280. My formula is
Code:
=(D5+MAX(D5-40,0)/2)*8, which is
=(35+MAX(35-40,0)/2)*8
=(35+MAX(-5,0)/2)*8
=(35+0/2)*8
=(35+0)*8
=35*8
...or $280. Right so far. And if D5 is 43 then it should be 40*8 + 3*8*1.5 = 320+24*1.5 = 320+36 = $356; my formula is
Code:
=(D5+MAX(D5-40,0)/2)*8
=(43+MAX(43-40,0)/2)*8
=(43+MAX(3,0)/2)*8
=(43+3/2)*8
=44.5*8
...or $356. So it looks to me like the formula I gave you is right. I thought you meant you tried it and it didn't work; but I guess you mean you tried it, and you see that it gives the correct results, you just don't understand
how it works. Right? You would like an explanation of how this calculates overtime?