How do I do this?

Payroll Below you will find a copy of a weekly payroll report. Each employee has received pay from a variety of methods. The employee could have worked regular hours, could have worked over- time hours, sick hours, vacation hours, holiday pay hours or other (like bereavement). Take the information that follows and key it into the Excel Spreadsheet and make sure you are on the PayRpt tab on the excel spreadsheet. Weekly Time Sheet and Time Report - #6: Employee Name Regular O/T Sick Vacation Holiday Other Hrs Hrs Hrs HE Hrs Hrs. TOTAL Hrs 16 40 40 56 16 8 40 40 16 8 Berev 40 W. Day 0 0 0 0 0 B. Myers-cook 40 C. Bunting-cook 24 M. Miller-food 40 server J. Jones-food 32 server D. Doster-food 40 server 1. Campbell 16 food server F. Chase 40 T. Hogg 40 0 C. Fisk 20 R. Phillips 15 Line server I. Iacobini 32 V. Murray 30 M. Winford 25 D. Dowling. 40 Secretary Total Hours/Col Additional Hrs Total Hrs in Week Payroll Dollars Total Payroll 40 40 0 20 15 8 40 30 25 40 Payroll Below you will find a copy of a weekly payroll report. Each employee has received pay from a variety of methods. The employee could have worked regular hours, could have worked over- time hours, sick hours, vacation hours, holiday pay hours or other (like bereavement). Take the information that follows and key it into the Excel Spreadsheet and make sure you are on the PayRpt tab on the excel spreadsheet. Weekly Time Sheet and Time Report - #6: Employee Name Regular O/T Sick Vacation Holiday Other Hrs Hrs Hrs HE Hrs Hrs. TOTAL Hrs 16 40 40 56 16 8 40 40 16 8 Berev 40 W. Day 0 0 0 0 0 B. Myers-cook 40 C. Bunting-cook 24 M. Miller-food 40 server J. Jones-food 32 server D. Doster-food 40 server 1. Campbell 16 food server F. Chase 40 T. Hogg 40 0 C. Fisk 20 R. Phillips 15 Line server I. Iacobini 32 V. Murray 30 M. Winford 25 D. Dowling. 40 Secretary Total Hours/Col Additional Hrs Total Hrs in Week Payroll Dollars Total Payroll 40 40 0 20 15 8 40 30 25 40