I need help solving the excel sheet

Payroll I 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 OIT Sick Vacation Holiday Other Hrs. Hrs Hrs Hr Hrs. Hrs. TOTAL Hrs 16 40 40 56 16 8 40 40 16 8 Berex 40 W.Day 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 I. Campbell 16 food server F. Chase 40 T. Hogg 40 0 C. Fisk 20 R. Phillips - 15 Line server I. lacobini V. Murray 30 M. Winford 25 D. Dowling 40 Secretary Total Hours/Col Additional Hrs Total Hrs in Week Payroll Dollars Total Payroll 0 40 40 0 20 15 32 8 40 30 25 40 ords DER English dinite DEN Axe Fare Del eyes Ne A E WIEX 0 Narne MANAGER NAME REG. PAY OF PAY TO PAY VAC HOL OTHER de 06 H 1000 SH OH 016 WW 3000 100 100 1000 10.00 10 1000 10 16 10 100 10 100 100 1000 003 1000 1000 000 9000 080 DE 06 001 W 1 000 09 0 1000 OT 0901 4 00 0904 01 090 WHO PA CONTER CARE Powy Rate Neser Vaere Hole One og OT GR 1120 Con $10.00 80 PL C SO CO Care (1100 00 J Sot dar 000 ET TO 6.00 ch 400 Cine 1 co pete ST M Eine 17 . 00 15 Une IPF 100 SY 60 Line 67 Dec Le 35 co 21 I Can ne 3720 De co Line 17 220 Banan 38.00 Vy tante 100 0 00 Cha Santin S7 TH Sanatum 37 Sant 1721 CP Santa 1725 Dd MW Santa 1726 RAS Sanat 57.5 000 10 W. Dy Santa $123 0.00 D De 39.00 000 ta t an ton v hng Thang Sicker Opole OTH 23 MENTER OTHER MOUR WORKED 26 TOTALS 00 000 0001 100 1000 1000 00 3001 NO 900 0901 2005 9000 1000 100 1000 1000 1000 1000 000 100 009 100 10 A De Shah 3000 3000 1000 1000 100 0 B000 100 VM 00 000 BO H00 3 100 300 0.00 h 1001 1200 000 100 10 W 100 1000 1000 1000 W . VARO OTHER HO 1000 10 1000 100 0006 3000 100 1000 DE TF TOR BED 0 Payroll I 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 OIT Sick Vacation Holiday Other Hrs. Hrs Hrs Hr Hrs. Hrs. TOTAL Hrs 16 40 40 56 16 8 40 40 16 8 Berex 40 W.Day 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 I. Campbell 16 food server F. Chase 40 T. Hogg 40 0 C. Fisk 20 R. Phillips - 15 Line server I. lacobini V. Murray 30 M. Winford 25 D. Dowling 40 Secretary Total Hours/Col Additional Hrs Total Hrs in Week Payroll Dollars Total Payroll 0 40 40 0 20 15 32 8 40 30 25 40 ords DER English dinite DEN Axe Fare Del eyes Ne A E WIEX 0 Narne MANAGER NAME REG. PAY OF PAY TO PAY VAC HOL OTHER de 06 H 1000 SH OH 016 WW 3000 100 100 1000 10.00 10 1000 10 16 10 100 10 100 100 1000 003 1000 1000 000 9000 080 DE 06 001 W 1 000 09 0 1000 OT 0901 4 00 0904 01 090 WHO PA CONTER CARE Powy Rate Neser Vaere Hole One og OT GR 1120 Con $10.00 80 PL C SO CO Care (1100 00 J Sot dar 000 ET TO 6.00 ch 400 Cine 1 co pete ST M Eine 17 . 00 15 Une IPF 100 SY 60 Line 67 Dec Le 35 co 21 I Can ne 3720 De co Line 17 220 Banan 38.00 Vy tante 100 0 00 Cha Santin S7 TH Sanatum 37 Sant 1721 CP Santa 1725 Dd MW Santa 1726 RAS Sanat 57.5 000 10 W. Dy Santa $123 0.00 D De 39.00 000 ta t an ton v hng Thang Sicker Opole OTH 23 MENTER OTHER MOUR WORKED 26 TOTALS 00 000 0001 100 1000 1000 00 3001 NO 900 0901 2005 9000 1000 100 1000 1000 1000 1000 000 100 009 100 10 A De Shah 3000 3000 1000 1000 100 0 B000 100 VM 00 000 BO H00 3 100 300 0.00 h 1001 1200 000 100 10 W 100 1000 1000 1000 W . VARO OTHER HO 1000 10 1000 100 0006 3000 100 1000 DE TF TOR BED 0