How to Do Time Sheets in Excel

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Do Time Sheets in Excel
Time cards can be used to automatically create time sheets. (Ryan McVay/Photodisc/Getty Images)

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


  1. 1

    Click "File," then "New." A new workbook window appears.

  2. 2

    Click "Time Sheets" in the left-hand column.

  3. 3

    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.

  4. 4

    Personalise the time sheet by entering your business information. For example, click on "[Company Name]" and then type your company name.

  5. 5

    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.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.