Skip to content
The title slide and first slides of the Weekly Timesheet template

Weekly Timesheet

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
3
Difficulty
Beginner
Updated
November 6, 2026

Every slide (3)

Overview

The Weekly Timesheet is a printable form for one person's working week. The Timesheet tab holds the employee details, the hourly rate and one row for each day. Hours are worked out from the start, finish and break times. Total hours, overtime and total pay calculate at the bottom of the form. The Week log tab keeps a record of approved weeks.

It comes with sample data for one employee's week and four weeks in the log. Make a copy and replace the sample rows. The formulas and totals update on their own.

Useful for

  • Recording hours for hourly paid staff each week
  • Working out overtime for a payroll submission
  • Keeping a signed record of each approved week

What's included

  • 3 tabs: Timesheet, Week log, How to use
  • Timesheet: a ready-to-fill form
  • Week log: a table
  • 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

Is this Weekly Timesheet template free?

Yes. Make a copy in Google Sheets or download the .xlsx file for Excel. There is no charge for the template.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Excel. The formulas and totals work there as well as in Google Sheets.

How is overtime worked out?

Overtime is total hours above 40 in the week. Those hours are paid at 1.5 times the hourly rate. You can change the 40 in the formula if your contract uses a different limit.

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

More timesheet templates

See all 3

Also in Human resources

All human resources templates
Get this template

Preparing your template…