Payroll analysis

D

Dillion23

Im trying to take a column of hours and figure the total net pay for
week, the problem is I need to seperate straight time from overtime. S
say I have 54 hours I need to figure 40hrs @8.50 an hour and 14hr
@12.75 an hour. What type of formula can I use to accomplish this
 
R

Ron Coderre

If hours worked are in A1
and Rate is in B1 then:
C1: =MIN(A1,40)*B1+MAX(A1-40,0)*1.5*B1


Does that help?

Regards,
Ron
 
M

Mladen_Dj

Use IF formula for your calculation. For example if time is in cell A1, use
formula:

=IF(A1<=40, A1*8.5, 40*8.5+(A1-40)*12.75)
 
Top