over time rates formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to calculate an overtime rate in an excel spreadsheet. Here is
the function I created. Can you see what I did wrong?

=IF(SUM($H$3:H8)<=8,H8*$D$69,(SUM($H$3:H8))-8)*($D$69*1.5)+((8-(SUM($H$3:H7))*($D$69)))

The logic is correct but it's giving me a negative number. Please help.

Kimber
 
Well, if you're getting a negative number, I'd suggest the logic isn't
correct.

It's hard to tell, though, unless you indicate what H3:H8 are.

If SUM(H3:H8) is total hours (though the True branch of your IF()
statement makes that seem unlikely), you can calculate total
compensation as something like:

=(SUM($H$3:$H$8)+0.5*MAX(SUM($H$3:$H$8)-8,0))*$D$69
 
Back
Top