Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
need help with a formula to calculate gross pay with 1.5 overtime rate with
<= 40 hrs Please help Thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculating overtime | New Users to Excel | |||
Calculating overtime | Excel Discussion (Misc queries) | |||
Calculating Overtime | Excel Worksheet Functions | |||
Need help calculating overtime to date | Excel Worksheet Functions | |||
Calculating overtime | New Users to Excel |