Payroll spreadsheet function help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am calculating employee regular, sick, vacation and overtime hours on a
spreadsheet I created. My colums are as follows:

[empl.] [sun, mon,... etc.(2wks)] [reg hours] [sick] [vac]
[holiday] [O/T] [Total]

How can I sum the reg hours (80 or less) in that colum and have the amount
80 go into the o/t colum?
Click to expand...
Also how can I enter hours for sick, vac or holiday so that they can be
recognized as sick, vac, etc. hours and then be totaled in the right column?
 
For the regular hours, you may use these formulas (supposing 10 columns with
days starting at B2)
[reg. hours] = MIN(80,SUM(B2:K2))
[O/T] = MAX (0,SUM(B2:K2)-80)
If you want to track the sick, vac and holidays in a daily basis, I would
recomend adding columns for them; if not, enter directly the figures in the
total columns.

Hope this helps,
Miguel.

Function rookie said:
I am calculating employee regular, sick, vacation and overtime hours on a
spreadsheet I created. My colums are as follows:

[empl.] [sun, mon,... etc.(2wks)] [reg hours] [sick] [vac]
[holiday] [O/T] [Total]

How can I sum the reg hours (80 or less) in that colum and have the amount
80 go into the o/t colum?
Click to expand...
Also how can I enter hours for sick, vac or holiday so that they can be
recognized as sick, vac, etc. hours and then be totaled in the right column?
Click to expand...
 
Back
Top