Payroll analysis
 

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


--
Dillion23
------------------------------------------------------------------------
Dillion23's Profile: http://www.excelforum.com/member.php...o&userid=28530
View this thread: http://www.excelforum.com/showthread...hreadid=481840

Payroll analysis
 

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=481840

Payroll analysis
 

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)


"Dillion23" wrote
in message ...

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


--
Dillion23