calculating pay with and without overtime

[lebanonfamous]

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

 

[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)

 

[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

 

[lebanonfamous]

thx needed the help brain freeze

Try this:

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

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

 

[lebanonfamous]

thx brain freeze here needed the help

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. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

thx needed the help brain freeze