View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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