A time sheet is a way of recording hours worked on a job or task. Time sheets can fine-tune your payroll processing and billing. There are different types of time sheets for payroll, billing, estimation and other management projects. Microsoft Excel templates offer a convenient way to start a time sheet system for your business: Simply download the template from Microsoft's website and you're ready to go.
- Skill level:
- Moderately Challenging
Other People Are Reading
Click "File," then "New." A new workbook window appears.
Click "Time Sheets" in the left-hand column.
Double-click an icon for the type of time sheet you'd like to create. For example, click "Monthly Time Sheet With Notes," "Weekly Time Sheet With Breaks" or "Biweekly Time Sheet." The time sheet downloads and opens in Excel.
Personalise the time sheet by entering your business information. For example, click on "[Company Name]" and then type your company name.
Modify the time sheet by clicking in a cell and typing the figure you need. For example, click on the "Time Out" cell and then type "10:45" to indicate that the employee clocked out at 10:45. Excel keeps track of hours and totals dynamically in most time sheets.
Tips and warnings
- Try several time sheets to see which one suits your needs best before committing to using one permanently. As of November 2010, Excel features 50 different time sheets, so you're bound to find one that suits your needs.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for