Payroll spreadsheet function help

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

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?

 

[Guest]

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.

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?

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?