Example Timesheet Template using Excel

Deploying timesheets with your staff can have a variety of benefits from controlling hours worked to more complicated activities such as recording what tasks are worked on, even down to supporting tasks such as job cost billing.

Creating a timesheet isn’t overly difficult and can be achieved with Microsoft Excel fairly easily.

Before starting – consider the information you want to record for example

• Employee Name
• What period the work reates to e.g. Week Number/Commence date
• What hours have been worked on which day
o What time rate (e.g. overtime standard)
o Total Hours worked
• Does it require authorization
• Do you need to capture hours not worked?

The timesheet template is divided into four main parts

1/ Titles – what the template is about

2/ Employee details – details such as a name, payroll number

3/ Hours Worked details – The hours worked and the remuneration

4/ Hours worked summary/totals – total of hours worked and a sign off element.

Example Timesheet Excel template video

Check out our video below that takes you through the steps in how to build a excel timesheet template:

Share These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • Furl
  • StumbleUpon
  • Technorati

Related posts:

  1. Training Matrix Template
  2. Example SWOT analysis and follow up action sheet built using Word & Excel
  3. How to carry out an ABC inventory analysis