Use this worksheet-style overtime pay calculator guide to estimate regular pay, overtime premiums, double-time amounts, and the labor cost of changing a schedule. You will learn which inputs to collect, how to convert salary to an hourly equivalent, how bonuses and multiple pay rates can affect the regular rate, and when to review the calculation before processing payroll.
Overview
Overtime calculations are simple only when the employee has one hourly rate, one type of premium, and a clearly defined overtime period. Real payrolls may involve salaried employees, multiple jobs, shift premiums, nondiscretionary bonuses, different workweeks, or local rules that differ from the assumptions used in a basic calculator.
The core calculation is:
Overtime pay = overtime hours × overtime rate
For a standard time-and-a-half assumption:
Overtime rate = regular rate of pay × 1.5
These formulas estimate gross wages before taxes, benefits, retirement contributions, garnishments, or other deductions. They do not determine whether an employee is legally entitled to overtime. Before relying on a result, confirm the employee’s classification, the applicable workweek, the overtime threshold, and any state, local, industry, contract, or collective-bargaining requirements.
A calculator is most useful as a repeatable decision tool. It can help you compare the cost of approving extra hours, identify unusual time records, prepare a payroll worksheet, or check whether a payroll system’s result appears reasonable. For a broader pre-payday review, pair the calculation with a payroll reconciliation checklist.
How to estimate overtime pay
1. Confirm the overtime period
Start with the period used by the applicable rule or company policy. Do not automatically treat a pay period as the overtime period. A weekly overtime rule may require you to review each workweek separately even when employees are paid biweekly. Enter the hours worked in each relevant workweek, then calculate overtime for each week rather than combining two weeks and dividing the total.
2. Separate regular and overtime hours
Record total compensable hours, regular hours, overtime hours, and any hours subject to a different premium. For a simple example, an employee works 46 hours in the applicable workweek and the overtime threshold is 40 hours. The worksheet would show:
- Regular hours: 40
- Overtime hours: 6
- Overtime multiplier: 1.5
Do not assume that every hour appearing on a timesheet is compensable or that every absence, break, training period, travel period, or leave category is treated the same way. Apply the rules and documented policy that govern the employee.
3. Calculate the regular rate
For a single-rate hourly employee with no additional includable earnings, the regular rate is usually the hourly rate used as the starting point for the premium calculation. If the employee earns $18 per hour, a time-and-a-half estimate is:
$18 × 1.5 = $27 overtime rate
Some payroll methods show the employee’s total pay as 40 hours at the regular rate plus 6 hours at the overtime rate. Other methods show all hours at the regular rate and add only the overtime premium. Both presentations can describe the same gross result if used consistently:
- 40 regular hours × $18 = $720
- 6 overtime hours × $27 = $162
- Total gross wages = $882
4. Add any separate premium category
If a rule or policy provides double time, use the applicable multiplier rather than automatically applying time and a half. With a $20 regular rate and 3 double-time hours:
$20 × 2.0 = $40 double-time rate
3 × $40 = $120 for the double-time hours
Double time may apply only to a defined type of work, schedule, or hour total. Treat it as a separate input in the worksheet and check whether overtime and double time overlap or whether only the higher premium applies.
Inputs and assumptions for an overtime calculation worksheet
A reliable overtime pay calculator should make its assumptions visible. Include these fields in an Excel or Google Sheets worksheet:
- Employee name or ID: Use an internal identifier when sharing reports.
- Workweek start and end: Record the period used for the calculation.
- Pay type: Hourly, salaried, piece-rate, commission, or another arrangement.
- Base rate: Enter the hourly rate or the salary amount and salary period.
- Regular hours: Enter hours that fall below the applicable overtime threshold.
- Overtime hours: Enter hours subject to the overtime multiplier.
- Double-time hours: Keep these separate where a different premium applies.
- Other earnings: List bonuses, shift differentials, commissions, or other payments that may affect the regular-rate analysis.
- Overtime multiplier: Enter the multiplier required by the applicable rule or policy.
- Rounding method: Document whether time is recorded in decimals, minutes, or another approved increment.
For a salaried employee, first calculate an hourly equivalent using the salary period and the assumed number of covered hours. For example, if a weekly salary is $960 and the salary is intended to cover 40 hours:
$960 ÷ 40 = $24 hourly equivalent
Six overtime hours at a 1.5 multiplier would produce an estimated overtime rate of $36 and estimated overtime wages of $216. This is a worksheet example, not a classification conclusion. Salary alone does not answer whether an employee is exempt or nonexempt, and the conversion method may depend on the governing rule and pay arrangement.
Bonuses and other earnings require additional care. A payment may or may not be included in the regular-rate calculation depending on its nature and the applicable requirements. Do not hide these amounts in a general total. Add a separate line, describe the payment, and document the treatment used. If the calculation is difficult to audit, use your small business payroll spreadsheet setup guide as a starting point for organizing rate and hour data.
Worked examples
Example 1: Hourly employee paid time and a half
An employee earns $22 per hour and works 44 hours in the applicable workweek. Assuming the overtime threshold is 40 hours and the multiplier is 1.5:
- Regular pay: 40 × $22 = $880
- Overtime rate: $22 × 1.5 = $33
- Overtime pay: 4 × $33 = $132
- Estimated gross wages: $880 + $132 = $1,012
If the employee’s pay stub needs to show regular and overtime earnings separately, review the required fields in the pay stub template guide.
Example 2: Two hourly rates in one workweek
An employee works 30 hours at $18 and 16 hours at $24. Total hours are 46. A basic calculation should not simply apply the $24 rate to every overtime hour. First identify the applicable regular-rate method, then document how the hours and rates are treated. If a weighted-average approach is required for the arrangement, the base earnings are:
- 30 × $18 = $540
- 16 × $24 = $384
- Total base earnings = $924
- Average rate across 46 hours = $924 ÷ 46 = $20.09, rounded only according to the approved method
The resulting overtime premium depends on the governing rule and whether other earnings must be included. This example shows why multiple rates should be flagged for review rather than handled by a single-rate calculator.
Example 3: Biweekly payroll
An employee is paid every two weeks and records 43 hours in week one and 37 hours in week two. If the applicable rule uses a weekly threshold of 40 hours, week one contains 3 overtime hours and week two contains no overtime hours. Do not average the 80 hours across the biweekly pay period to conclude that overtime is zero. Use the workweek structure required for the employee and jurisdiction, then transfer the results into the biweekly payroll run.
When to recalculate
Revisit the overtime worksheet whenever an input changes. The most common triggers are a pay-rate increase, a new work schedule, a change in job duties or classification, a bonus or commission payment, a shift differential, a transfer between jobs, a new workweek definition, or a different overtime or double-time rule.
Review the calculation before every payroll run when overtime hours are present. Also perform a broader review at year-end and whenever labor requirements, salary thresholds, minimum-wage rules, premium rules, or local guidance may have changed. Because requirements vary, confirm current rules through an appropriate official or qualified payroll resource rather than relying on an old worksheet assumption.
For a practical workflow, complete these steps:
- Export or collect approved time records.
- Separate each employee’s hours by workweek, rate, and premium category.
- Check classification and the overtime assumptions used.
- Enter regular, overtime, double-time, and additional earnings separately.
- Compare the worksheet with the payroll system’s calculation.
- Investigate differences before final approval.
- Retain the time records, assumptions, approvals, and calculation notes with payroll records.
Use the worksheet as an estimate and control check, not as a substitute for reviewing the rules that apply to a particular employee. When the result feeds payroll, confirm the final figures against your payroll records, deduction worksheet, tax schedule, and reconciliation process.