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?