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

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

Try this:

A1 = hourly rate
A2 = total hours (in decimal format: 48)

=A1*MIN(40,A2)+A1*1.5*MAX(0,A2-40)

--
Biff
Microsoft Excel MVP


"lebanonfamous" wrote in message
...
need help with a formula to calculate gross pay with 1.5 overtime rate
with
<= 40 hrs Please help Thanks

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

thx needed the help brain freeze

"T. Valko" wrote:

Try this:

A1 = hourly rate
A2 = total hours (in decimal format: 48)

=A1*MIN(40,A2)+A1*1.5*MAX(0,A2-40)

--
Biff
Microsoft Excel MVP


"lebanonfamous" wrote in message
...
need help with a formula to calculate gross pay with 1.5 overtime rate
with
<= 40 hrs Please help Thanks

thx brain freeze here needed the help


"ShaneDevenshire" wrote:

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

You're welcome!

--
Biff
Microsoft Excel MVP


"lebanonfamous" wrote in message
...
thx needed the help brain freeze

"T. Valko" wrote:

Try this:

A1 = hourly rate
A2 = total hours (in decimal format: 48)

=A1*MIN(40,A2)+A1*1.5*MAX(0,A2-40)

--
Biff
Microsoft Excel MVP


"lebanonfamous" wrote in
message
...
need help with a formula to calculate gross pay with 1.5 overtime rate
with
<= 40 hrs Please help Thanks