payroll calculations

[TammyNC]

I need help!! I have a payroll sheet that has salary and hourly employees on it. I need to calculate their gross weekly pay and I need to do it in one formulal. So I have M2 is salary or hourly, N2 is payrate, and O2 is hours worked. P2 is my destination cell. I have to calculate overtime at 1.5 for those over 40 hours but there are some that are salary employees that do not get overtime but I still have to calculate their weekly gross pay. I have tried every formula I can think of to get this into one formula its the salary and hourly thats killing me. Can anyone help?? I can provide samples if needed.

Thanks in advance

 

[home_toast]

How do you differentiate the salaried and hourly employees in your Excel file?

TJ

 

[TammyNC]

they are listed as salary or hourly in the column

 

[home_toast]

I assume that you know the calculations for both salaried and hourly employees so if you want to get this all into one formula:

=IF(M2="salary",[calculation for salaried employee], IF(M2="hourly",[calculation for hourly employee]))

HTH

TJ

 

[Dryver14]

This works on my sheet

=IF(M7="Salary",O7*N7,IF(O7<=40,O7*N7,(O7*1.5)*N7))

Where I have put 40 this assumes the hours for a normal week before O/Time

 

[Dryver14]

Wait,

Its wrong isnt it. I have calculated the overtime rate for all hours not just
those over 40 let me think on......

 

[Dryver14]

Sorry,

I think this is it

Remember I am basing this on a 40 hr week

=IF(M7="Salary",O7*N7,IF(O7<=40,O7*N7,(N7*40)+(O7-40)*(N7*1.5)))

 

[home_toast]

Assuming 40 hours per week:

=IF(M2="salary",N2*O2, IF(M2="hourly",IF(O2>40,((O2-40)*(N2*1.5))+(N2*40),N2*O2)))

HTH

TJ

 

[Dryver14]

Dont know why I started in M7 !!!
I meant M2

 

[TammyNC]

thank you guys that was exactly what I was looking for the only thing I had to change was in the salary calculation it was "salary",N2/52 to get the weekly total for salary. it works great yall rock!