Everhour supports overtime planning and review, but spreadsheet formulas still need the right workweek, rate, and employee status.
Calculate regular and overtime earnings based on your hours and rate. Supports standard time-and-a-half and double-time multipliers.
Total hours including overtime
Typically 40h/week
The calculator gives you the number — Everhour takes it from there.
One click and you're timing. Start a timer, add an entry, edit the details. This is exactly how it feels in Everhour.
Set a budget, assign rates, and get alerted before you're over.
Measurement
Track your budget through time or costs
Every report you need — configured your way, always up to date.
Tracked hours flow straight into a polished invoice — no copy-paste, no manual math.
An overtime spreadsheet template answers one practical question: what gross pay is due for a covered nonexempt employee in one fixed workweek? Under the FLSA federal baseline, covered nonexempt employees must receive overtime pay for hours worked over 40 in a workweek at not less than 1.5x the employee's regular rate of pay.
The template should separate inputs from results. Inputs include employee name, fixed workweek dates, total hours actually worked, regular rate or compensation basis, overtime threshold, and overtime multiplier. Results include regular hours, overtime hours, regular pay, overtime pay, and total gross pay. Holiday, vacation, and other time not worked should not be treated as worked hours unless policy, contract, or state law says so.
Use one row per employee per fixed workweek. The FLSA workweek is a fixed and regularly recurring 168-hour period made of seven consecutive 24-hour periods, and each workweek stands alone. Do not average a 35-hour week with a 45-hour week to erase overtime in the second week.
Keep separate columns for worked hours, paid nonworked hours, regular rate, overtime rate, and gross pay. This prevents a common spreadsheet mistake: adding holiday or vacation pay into worked hours before testing the 40-hour threshold. The FLSA does not require payment for time not worked, including vacations or federal or non-federal holidays; those benefits are generally set by agreement, policy, or a representative or union contract.
For a simple hourly example, assume a covered nonexempt employee works 51 hours in one fixed FLSA workweek at a $31.60 regular hourly rate. Regular hours are capped at 40, overtime hours are 11, and the overtime rate is $31.60 × 1.5 = $47.40.
Regular pay is 40 × $31.60 = $1,264.00. Overtime pay is 11 × $47.40 = $521.40. Total gross pay is $1,264.00 + $521.40 = $1,785.40. If the employee has bonuses or multiple pay rates in the same workweek, calculate the regular rate as total compensation for the workweek, excluding statutory exclusions, divided by total hours actually worked.
A spreadsheet is enough for a one-off gross pay check, a small correction, or a quick comparison between expected and paid overtime. It is not enough when managers need approved time records, late-entry controls, planned workload visibility, payroll handoff, or a consistent record across multiple people and projects.
Everhour Resource Planning gives managers visual timelines with member and project views, weekly capacity, availability gaps, scheduled time off, and planned-vs-actual comparisons. That matters before overtime is created: you can see overloaded schedules earlier, adjust assignments, and use tracked time for review instead of rebuilding the week from a spreadsheet after work is done.
This content is for general information only, may not be fully up to date, and is provided without any warranty or liability.
High Performer
G2
Summer 2026
Best Ease Of Use
Capterra
Summer 2026
Rated in the top time trackers across G2, Capterra, and TrustRadius — with consistent praise for ease of use, integrations, and support.
Include employee name, workweek start date, workweek end date, worked hours, paid nonworked hours, regular rate, regular hours, overtime hours, overtime multiplier, overtime rate, regular pay, overtime pay, and total gross pay. Keep notes for policy, contract, or state-law exceptions so the spreadsheet does not hide why a calculation changed.
Not for a federal-baseline template. The FLSA federal baseline does not create daily overtime; the federal trigger is hours worked over 40 in a fixed workweek for covered nonexempt employees. Add daily overtime columns only when a more protective state rule, policy, contract, or worker category requires them.
Use separate calculation rows for each fixed workweek. Each FLSA workweek stands alone for overtime, and hours may not be averaged over two or more workweeks to avoid overtime. A payroll period can contain multiple workweeks, but the overtime test still runs workweek by workweek.
Put holiday pay for time not worked in a separate paid-nonworked-hours or earnings column. The FLSA does not require payment for holidays or vacations, and those benefits are generally set by agreement, policy, or a representative or union contract. Do not count nonworked holiday hours as worked hours for the federal 40-hour overtime threshold.
The biggest error is using base hourly wage when the regular rate should include other compensation for the workweek. The regular rate is total compensation for the workweek, excluding statutory exclusions, divided by total hours actually worked. A second common error is combining multiple workweeks before testing the 40-hour threshold.
Everhour Resource Planning shows workload on visual timelines with member and project views, weekly capacity, availability gaps, scheduled time off, and planned-vs-actual time. Managers can spot overloaded schedules before the week closes and adjust assignments before overtime becomes a payroll issue.
Everhour Reporting can surface overtime and double-overtime data in Team Hours and configurable reports when overtime tracking is enabled. Reports can be filtered, grouped, exported to CSV, Excel/XLSX, or PDF, and used as review files before payroll or billing work.
Use Everhour Resource Planning to compare assignments, capacity, time off, and actual tracked time before spreadsheet cleanup becomes the weekly overtime process.
14-day free trial · No credit card · Cancel anytime
