Hi,

Suppose the hours are in A1 and the rate is in J12 then

=IF(A1<=40,A1*$J$12,40*$J$12+(A1-40)*1.5*$J$12)

--
Thanks,
Shane Devenshire


"lebanonfamous" wrote:

need help with a formula to calculate gross pay with 1.5 overtime rate with
<= 40 hrs Please help Thanks