L
lebanonfamous
need help with a formula to calculate gross pay with 1.5 overtime rate with
<=> 40 hrs Please help Thanks
<=> 40 hrs Please help Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
Try this:
A1 = hourly rate
A2 = total hours (in decimal format: 48)
=A1*MIN(40,A2)+A1*1.5*MAX(0,A2-40)
A1 = hourly rate
A2 = total hours (in decimal format: 48)
=A1*MIN(40,A2)+A1*1.5*MAX(0,A2-40)
S
ShaneDevenshire
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
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
L
lebanonfamous
thx needed the help brain freeze
T. Valko said:Try this:
A1 = hourly rate
A2 = total hours (in decimal format: 48)
=A1*MIN(40,A2)+A1*1.5*MAX(0,A2-40)
L
lebanonfamous
thx brain freeze here needed the help
ShaneDevenshire said: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
T
T. Valko
You're welcome!
--
Biff
Microsoft Excel MVP
--
Biff
Microsoft Excel MVP
lebanonfamous said:thx needed the help brain freeze