How do I write a formula in excel that calculates payroll?

  • Thread starter Excel overtime formula
  • Start date
E

Excel overtime formula

I need to write an excel formula that calculates hourly wages up to 30 hours
and then time and a half after 30 hours in one formula.
 
N

Naz

If say the hourley wage if £15 and hour, and the hours are in cell a1

=IF(A1<=30,15*A1,22.5*A1)

of course you could and should have the hourley rate in a cell
 
S

Sandy Mann

Naz said:
If say the hourley wage if £15 and hour, and the hours are in cell a1

=IF(A1<=30,15*A1,22.5*A1)
Click to expand...

That would pay ALL hours at the overtime rate if the employee worked more
than 30 hours

Try:


=MIN(A1,30)*15+MAX(A1-30,0)*22.5

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
 
N

Naz

And the problem with that would be?? ;-)
I apologise for the oversight the formula should of course read

=IF(A1<=30,15*A1,30*15+((A1-30)*22.5))
 
Top