Download a Free Excel Biweekly Timesheet Template

Use this free template from Microsoft in your business

Todd Davidson PTY LTD. / Getty Images

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

Downloading 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 meets your needs.

If it does: 

  1. Click on the Download button on the template page.
  2. Microsoft Excel may open with the timesheet template loaded into the program. If not, open Excel and open the template.
  3. Save the template to your computer.

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

Biweekly Time Sheet Template Features

Keep these points in mind when using the biweekly timesheet template:

  • Enter the starting date for the two-week period in cell H4 next to "Pay Period Start Date." The rest of the dates are added automatically.
  • Enter the employee's pay rate in cells D24, E24, F24, and G24. It may be the same for all four categories, but it is usually higher for the Overtime category.
  • The timesheet is designed so that all the details of the timesheet, such as the company name, employee name, manager's name as well as the 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—you can save time by entering all the unchanging information and then save the timesheet as a separate template using Excel's own Save as Template capability.
  • Do not write in column H, row 23, or row 25 on the template. The Total column (column H), the Total hours row (row 23), and the Total pay row (row 25) all contain formulas that calculate the number of hours worked per day, the number of hours worked per week, and the total pay owed to the employee.​​
  • Similarly, do not make entries in column C or in cell H5. They contain formulas that affect the dates for the two-week period of the timesheet.
  • 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 all the math after you make all the entries.
mla apa chicago
Your Citation
French, Ted. "Download a Free Excel Biweekly Timesheet Template." ThoughtCo, Jan. 14, 2018, French, Ted. (2018, January 14). Download a Free Excel Biweekly Timesheet Template. Retrieved from French, Ted. "Download a Free Excel Biweekly Timesheet Template." ThoughtCo. (accessed March 21, 2018).