Download a free biweekly Excel schedule template

Contents
  1. Use this free template from Microsoft for your business
  2. Download the timesheet template from the Microsoft website
  3. Biweekly Template Features

Use this free template from Microsoft for your business

This article will show you how to download and use a free biweekly timesheet template in Excel. The total number of hours worked and the total wage are calculated automatically. The template is located on the Microsoft website and can be downloaded for free.

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

Download the timesheet template from the Microsoft website

Click here link to template in your favorite browser to open the template page. Check out the template to see if it fits your needs. If:

  1. Press the button To download on the template page.

    Before downloading, the Microsoft website may check if a licensed copy of Microsoft Excel is running on your computer.

  2. Depending on how your browser is set up, the schedule template can be opened in Excel or downloaded to your computer.

  3. Once the timetable template has been downloaded to your computer, open the file in Excel.

  4. Select Enable editing to make changes to the schedule template.

Biweekly Template Features

Keep this in mind when using the biweekly schedule template:

  • Enter the start date of the two-week period in cell G8 next to Pay Period Start Date. Other dates are added automatically.

  • Enter the employee’s wage rate in cells C28, D28, E28, and E28. May be the same for all four categories, but usually higher for the overtime category.

  • The timesheet is designed so that all table data such as company name, employee name, manager name, hours worked and wage rate can be printed next to the corresponding header before the sheet is printed.

  • If you have information that doesn’t change from pay period to pay period, such as a company name, you can save time by entering the same information and then saving the timesheet as an Excel template.

  • Do not write in column G, line 27, or line 29 in the pattern. Column Total (column G), row Total hours (line 27) and line Total payment (line 29) contain formulas. These formulas calculate the number of hours worked per day, the number of hours worked per week, and the employee’s total wages.

  • Do not enter data in column B or cell G9. These cells contain formulas that affect dates in a two-week timesheet period.

  • To use the timesheet, enter the hours worked per day using the following four categories: regular hours, overtime, sick, and vacation. The spreadsheet does the math after you enter your time.

Leave a Reply

Your email address will not be published. Required fields are marked *