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