calculating pay with and without overtime
Hi,
Here is a shorter formula to do the same thing with the rate in B1 and the
hours in A1
=MAX(A1,40+(A1-40)*1.5)*$B$1
--
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
|