| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
|
#4
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| feel that the STANDARD DEVIATION formula on Excel is incorrect !! | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Hybrid Mode
