Download a Free Excel Biweekly Time Sheet Template

Use this free template from Microsoft in your business

BUSINESSMAN PUNCHING TIME CARD
Todd Davidson PTY LTD. / Getty Images

This article shows you how to download and use a free biweekly time sheet template in Excel. The total hours worked and the total pay are calculated automatically. The template is located on Microsoft's website and is a free download.

Note: The information in this article applies to Excel versions 2019, 2016, 2013, 2010, Excel Online, and Excel for Mac.

Download the Time Sheet Template From Microsoft's Website

Click on this template link in your favorite browser to open the template page. Examine the template to see if it meets your needs. If it does: 

  1. Select the Download button on the template page.

    A screenshot showing where to download the Excel Biweekly time sheet template

    Before the download begins, Microsoft's website may check to ensure that your computer is running a licensed copy of Microsoft Excel.

  2. Depending on how your browser is set up, the time sheet template may either open in Excel or download to your computer.

  3. If the time sheet template downloaded to your computer, open the file in Excel.

    A screenshot of the free Excel timesheet template
  4. Select Enable Editing to make changes to the time sheet template.

Biweekly Time Sheet Template Features

Keep these points in mind when using the biweekly time sheet template:

  • Enter the start date for the two-week period in cell G8 next to "Pay Period Start Date." The rest of the dates are added automatically.
  • Enter the employee's pay rate in cells C28, D28, E28, and E28. It may be the same for all four categories, but it is usually higher for the Overtime category.
  • The time sheet is designed so that all the details of the time sheet, such as the company name, employee name, manager name, hours worked, and rate of pay can be typed in beside the appropriate heading before the sheet is printed.
  • If you have information that does not change from pay period to pay period, such as the company name, save time by entering all the unchanging information and then save the time sheet as an Excel template.
  • Do not write in column G, row 27, or row 29 on the template. The Total column (column G), the Total hours row (row 27), and the Total pay row (row 29) contain formulas. These formulas calculate the number of hours worked per day, the number of hours worked per week, and the total pay owed to the employee.​​
  • Do not make entries in column B or in cell G9. These cells contain formulas that affect the dates for the two-week period of the time sheet.
  • To use the time sheet, enter the hours worked each day using the following four categories: Regular Hours, Overtime Hours, Sick and Vacation. The spreadsheet does the math after you enter your time.