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

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

Guest

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.
 
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
 
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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula to calculate wages 4
Calculate After hours 3
Excel Catagorise AM or PM 7
Payroll calculations for real time 2
Excel - Sliding decreasing scale (payroll tax calc) 2
Calculating payroll cost 1
Calculating time for 3rd shift 4
How do I setup a formula for payroll deductions in excel 1

Back
Top