Free calculator
Overtime calculator
Enter your straight hourly rate, standard weekly hours before overtime (default 40), total hours worked in that week, and an overtime multiplier on the straight rate (often 1.5 for time-and-a-half, 2 for double time). We show regular pay, overtime pay, and total gross as a transparent illustration—not payroll software. To total clock hours first, use the time card calculator for a week grid or the work time calculator for a single shift—both are linked below.
When to use this calculator
Quick gross checks for the common weekly cap + multiplier pattern before you mirror it in Sheets or Excel—not a substitute for payroll engines.
- Estimate regular vs overtime hours when you already know total weekly hours and your cap (often 40 in US teaching examples).
- Compare 1.5× vs 2× (or a custom factor your contract states) on the same overtime hours.
- Copy the spreadsheet pattern from this page into a workbook row when you need rate × hours × multiplier transparency.
- Switch to the time card calculator when you need clock in/out rows for the whole week, or the work time calculator for one shift with breaks.
We use a single-week, single-rate illustration: hours up to your cap earn rate × hours; each hour above the cap earns rate × multiplier.
Split hours
Regular hours = min(hours worked, cap). Overtime hours = max(0, hours worked − cap). Fractional hours are allowed if you enter decimals.
Pay lines
Regular pay = rate × regular hours. Overtime pay = rate × overtime hours × multiplier. Total = regular pay + overtime pay, each rounded to two decimals for display.
What we do not model
Blended regular rate (bonuses/tips), California-style daily OT, bi-weekly caps, salary exempt tests, taxes, or night/weekend premiums unless you fold them into your own multiplier—ask HR for real rules.
Official U.S. overtime guidance for employers and workers is published by the U.S. Department of Labor—this page is not that advisor.
For one shift with clock in, clock out, and unpaid break minutes, use the work time calculator.
For a Monday–Sunday time card grid, use the time card calculator.
Google Sheets & Excel
Model one week in cells: cap, hours worked, straight rate, and multiplier. Regular hours are MIN(hours, cap); overtime hours are MAX(0, hours-cap); overtime pay is rate * otHours * multiplier.
=MAX(0,B2-A2)*C2*D2A2 = standard-hours cap; B2 = total hours worked in the week; C2 = straight hourly rate; D2 = overtime multiplier (e.g. 1.5). Add MIN(B2,A2)*C2 in another cell for regular pay.
More tools in Planning
Browse all toolsSlide 1 of 24
Frequently asked questions
How is this different from the time card calculator?
The time card calculator adds clock in/out and break minutes across seven rows to get weekly hours. This page starts from total weekly hours and a rate to estimate gross pay with an overtime multiplier—use the time card when you need the hours first.
How is this different from the work time calculator?
The work time calculator covers one day: start, end, and unpaid break → net hours. It can optionally multiply by a rate for a day illustration. This page is week-level hours over a cap with a multiplier on extra hours.
Is “time and a half” the same as multiplier 1.5?
In common U.S. English, time and a half means 1.5 × the straight hourly rate for each overtime hour. Enter 1.5 in the multiplier field for that pattern.
Why is 40 the default cap?
Many introductory examples use a 40-hour weekly threshold before overtime. Your contract or local law may use a different cap—change the standard hours field to match what you are modeling.
Does this subtract taxes or show take-home pay?
No. Totals are simple gross illustrations only. Payroll taxes, benefits, and garnishments require your payroll system or a dedicated tax tool.
Do you handle daily overtime (e.g. over 8 hours in a day)?
Not in v1. This tool only looks at one weekly total vs one cap. If your rules depend on per-day thresholds, model each day in a spreadsheet or use HR tools.
I am salaried—does this say if I am exempt from overtime?
No. Exempt vs non-exempt status depends on duties, salary tests, and jurisdiction—this calculator does not classify jobs. It only does math on the numbers you enter.
Does this apply my country or union rules automatically?
No. Germany, France, and other systems can use different thresholds, premiums, and contingents. We give a transparent multiplier you control; verify Tarifvertrag, convention collective, or statutory rules with qualified professionals.
How do I match this in Google Sheets or Excel?
Use MIN/MAX with your cap, hours, rate, and multiplier as in the copy card on this page—keep hours and rate in consistent units.
Is this legal or payroll advice?
No. It is a free math helper. For compliance questions, use official sources and qualified advisors.