Skip to content
Biweekly Timesheet cover: a sample sheet with hours logged, overtime hours and pay to date and a column chart, beside the Dashboard and Timesheet tabs

Biweekly Timesheet

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Biweekly Timesheet is for employees and supervisors whose pay runs every two weeks. The Timesheet tab is a print-ready form headed by name, department, supervisor, hourly rate and period dates at the top, a grid for ten working days with start, finish and unpaid break times, and totals for hours, overtime and pay. The Pay periods tab keeps a running record of each period with its hours, overtime, pay and whether it is Waiting, Approved or Paid.

Fill in the period dates before any times, so the sheet and the payroll calendar match. Enter your overtime threshold in the Hours before overtime line, after comparing it with your own contract, since rules differ by employer and location. Once a supervisor signs, copy the totals across to the Pay periods tab, so the dashboard can total the pay that has cleared approval but still awaits payment.

Useful for

  • Record hours for each two-week pay period without missed days
  • Check overtime before a period is sent to payroll for approval
  • Keep a running list of periods that are waiting, approved or paid

What's included

  • 4 tabs: Dashboard, Timesheet, Pay periods, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Timesheet: a ready-to-fill form
  • Pay periods: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Timesheet tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I enter a day off or a holiday?

Leave both time cells blank for that day, and the hours column stays empty. If you were paid for the day anyway, enter the hours in the start and finish cells instead. The totals only add up the hours that are actually filled in.

Why do the hours show a negative number?

A negative figure usually means the finish time is earlier than the start time, such as a shift that runs past midnight. Enter the finish time as the following day's time, or split the shift into two rows so the total is correct.

Can I change the overtime rule for this sheet?

Yes. Edit the Hours before overtime cell and the 1.5 multiplier in the Total pay formula. The Pay periods tab uses the same multiplier, so change it there as well if your rule is different.

  • #timesheet
  • #biweekly-timesheet
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More timesheet templates

See all 10

Also in Human resources

All human resources templates
Get this template

Preparing your template…