Skip to content
Overtime Hours Calculator cover: a sample sheet with hours logged, overtime hours and overtime pay and a bar chart, beside the Dashboard and Weeks tabs

Overtime Hours Calculator

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

The Overtime Hours Calculator is for supervisors, payroll clerks and small business owners who pay staff by the hour. The Weeks tab keeps a row for each employee and week, showing hours worked and hourly rate. Overtime hours, overtime pay and total pay fill in by formula. The Dashboard totals the hours and pay for the period and shows overtime by person in a bar chart.

Overwrite the sample rows with real weekly totals, newest week first. The 40-hour threshold and the 1.5 multiplier are written into the formulas, so check them against federal and state rules and your company policy before anyone is paid. Weeks over 50 hours turn red so long hours stand out. Copy the file each quarter to keep an archive.

Useful for

  • Work out overtime for hourly staff each week
  • Check a payroll run before it goes out
  • Spot people working very long weeks

What's included

  • 3 tabs: Dashboard, Weeks, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Weeks: 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 Weeks 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

What counts as overtime in the US?

Under the federal Fair Labor Standards Act, most hourly employees must get at least 1.5 times their regular rate for hours over 40 in one workweek. Some states add daily overtime or stricter rules, and some workers are exempt. Check current US Department of Labor guidance and your state law before you rely on this sheet.

Can I change the 40-hour limit or the 1.5 multiplier?

Yes, but they are typed into the formulas on the Weeks tab. Open Find and replace, search the Overtime hours and Overtime pay formulas, and change 40 or 1.5 to your own figures in each one. Then check the result against one week you have already paid by hand.

How do I handle a week that crosses two pay periods?

Enter each week by its starting date and count the hours worked in that week, not the pay period. If your payroll system pays by period, split the amounts there, and keep the weekly total here so overtime is worked out on whole weeks.

  • #timesheet
  • #overtime-calculator
  • #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…