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

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.

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

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,
London


"Excel overtime formula" wrote:

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.

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

"Naz" wrote in message
...
If say the hourley wage if £15 and hour, and the hours are in cell a1

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

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

Replace@mailinator with @tiscali.co.uk

"Naz" wrote in message
...
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,
London


"Excel overtime formula" wrote:

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.

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

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))



--

_______________________
Naz,
London


"Sandy Mann" wrote:

"Naz" wrote in message
...
If say the hourley wage if £15 and hour, and the hours are in cell a1

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

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

Replace@mailinator with @tiscali.co.uk

"Naz" wrote in message
...
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,
London


"Excel overtime formula" wrote:

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.