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 is a free download.

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

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:

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

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 timesheet 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 timesheet is designed so that all the details of the timesheet, 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 timesheet 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 timesheet.
• To use the timesheet, 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.