EMPLOYEE+TIMESHEET


 * An employee time sheet holds information from the weekly time sheets submitted by each employee and calculates the total payroll amount for the week.**

Good record keeping is important for managing staff payroll costs. Every week employees submit a time sheet to you indicating the number of hours they worked each day and the total hours for the week.

//You will create a spreadsheet where you will enter the information contained in the time sheets. This spreadsheet will provide you with an overall picture of the housrs each employee worked and the total payroll costs for that week. The information will be used in preparing the Payroll Register.//


 * Strategies:**
 * A time sheet schedule should include your employees' names and the days and hours they worked during the week being reported.
 * Accurate records are essential since this information will be used to calculate payroll.
 * Format your form for ease of use.

//Refer to// //Amanda's example for guidance. Do not the content or design of the example.//
 * Instructions:**


 * 1) Create a new workbook and save it as "Employee Timesheet"
 * 2) Set the page orientation to landscape.
 * 3) In cell A1, key the following title//: // Employee Timesheet Schedule
 * 4) Format the text in cell A1 to 20 point bold.
 * 5) Merge and center align the title in cell A1 across 11 columns of the spreadsheet
 * 6) In cells A3 - K3 key the following column headings: //Employee Name, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday, Total Weekly Hours, Pay Rate,// and //Gross Weekly Pay.//


 * Note:** //Adjust row heights and column widths when needed so that all data displays// // properly. //

7. Bold and center align cells A3 - K3. // 8. //Copy and paste the employee names and pay rates from your Employee Roster into the spreadsheet. 9. Key your employees' timesheet information into the spreadsheet. 10. Enter the formula =SUM(B4:H4) into cell I4 to compute the Total Weekly Hours for the employee in row 4. 11. Enter formulas into the remaining cells in that column for each employee listed. 12. Enter the formula =I4*J4 (Total Weekly Hours x Pay Rate) into cell K4 to compute the Gross Weekly Pay. 13. Enter formulas into the remaining cells in that column for each employee listed. 14. In the cell below the last Employee Name, key the following text: //Total Weekly Pay// 15, Using a formula in the cell below the last Gross Weekly Pay value to computer the cost of the total weekly pay for all employees.(The formula will begin with =SUM) 16. Carefully proofread your work for accuracy, format, spelling, and grammar, then resave.

//[|Example of Amanda's Employee Timesheet Schedule]//