View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Raza Raza is offline
external usenet poster
 
Posts: 26
Default mutiply by either REG or OT hours, and SUM!

I am trying to figure out a way to quickly generate a gross payroll number
without the aid of a 'helper' row, which won't work this situation. I have
about 60 employees.

Sample:
NAME(A) PAY(B) REG(C) OT(D)
Joe Worker 8 40
Jane Workr 8
Big Slacker 7.5 15
MR No Life 10 80 12

Mr. No Life also gets overtime at 1.5x his normal rate. The correct sum for
this would be $1412.50.

Any help?