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
|