TL;DR / Summary: Overtime pay looks simple until you mix daily overtime, weekly overtime, shift premiums, and tax withholding. Convert every hour into a gross line first, then apply your usual withholdings to estimate take-home—never multiply overtime hours by net hourly pay.
Separate base hours from premium hours
Start with the contract definition of a normal week. Forty hours is common, but some schedules use eighty hours over two weeks or a daily threshold such as eight hours.
List regular hours and overtime hours on different lines. Mixing them into one total before you apply the premium rate is the most common spreadsheet mistake.
If your workplace pays daily overtime after eight hours and also weekly overtime after forty, confirm which rule wins when both could apply. Double-counting premiums inflates the estimate; ignoring one understates it.
Find the true overtime multiplier
“Time and a half” means 1.5 × the regular rate for those hours. Double time is 2.0 ×. Some union agreements use 1.5 after eight and 2.0 after twelve on the same day.
Write the multiplier next to each overtime block. Do not average multipliers across the week unless every overtime hour truly shares the same rate.
Shift differentials
Night or weekend differentials are often a flat add-on per hour, not a multiplier. Add the differential to the base rate before or after the overtime multiplier—follow the handbook wording exactly.
- If the differential is “added to base, then overtime applies,” compute (base + differential) × 1.5
- If overtime uses base only and differential is separate, compute base × 1.5 + differential
- If the differential replaces overtime on Sundays, do not stack both
One wrong order can move the weekly gross by a noticeable amount on a long week.
Build the gross week as a stack of lines
A clean layout is: regular hours × base rate, overtime block A × rate A, overtime block B × rate B, differentials, then bonuses that are paid that week. Sum to weekly gross.
Exclude reimbursements such as mileage. They are not wages and should not enter the overtime math or the tax estimate the same way.
When the numbers get messy—multiple rates across one paycheck—the calculators at Calculation Assistant help you keep each line independent before you sum. Independent lines are easier to audit against a payslip.
Withholding is not a flat percentage of overtime alone
People often take their usual net hourly rate and multiply by overtime hours. That understates tax because overtime raises the gross for the pay period, and many withholding methods look at the period total.
A practical estimate: take last month’s average effective withholding rate (taxes + mandatory deductions ÷ gross) and apply it to the new weekly gross. It is not exact, but it beats pretending overtime is tax-free.
Estimate take-home from the full week’s gross, not from overtime hours in isolation.
Benefits deductions that are fixed per pay period stay fixed. Percentage-based retirement contributions rise with gross unless you have already hit a contribution cap.
Salary workers with overtime eligibility
Some salaried roles are overtime-eligible. Convert salary to a regular hourly rate the way payroll does—usually weekly salary ÷ regular hours—then apply the same overtime rules.
Do not invent an hourly rate by dividing annual salary by 2,080 if payroll uses a different divisor. Match the method on your last payslip.
If you are overtime-exempt, extra hours do not change the paycheck. The calculator still helps you decide whether the unpaid hours are worth the trade-off in time, but the money column stays flat.
Compare two weeks before you accept the shift
Run the week without the extra shifts and the week with them. The difference is the true overtime premium in your pocket after withholding.
Sometimes a short high-premium shift beats a long low-premium one after tax and after sleep. Seeing both totals side by side makes that comparison concrete.
Non-money costs to note beside the sheet
- commute time that is unpaid
- childcare that only appears on overtime nights
- fatigue that spills into the next regular shift
Those costs do not belong in the wage formula, but they belong on the decision page next to the take-home estimate.
Check the payslip against your sheet
When the paycheck arrives, line up each premium code with your blocks. If payroll used a different daily cutoff, update your template so the next estimate is closer.
Watch for “makeup” hours that cancel overtime—some policies require short days earlier in the week to offset a long day later. Your sheet should reflect the same policy.
A payslip is the calibration tool for next week’s estimate.
If tips or commissions appear in the same week, confirm whether they enter the regular rate calculation for overtime. That rule varies by jurisdiction and industry.
Keep a personal overtime template
Save your rates, differentials, and withholding estimate method in one place. Changing jobs means rebuilding the template; staying in the same role means updating rates once a year.
Label the sheet with the effective date of the rates. Old multipliers create false confidence.
The goal is a weekly take-home figure you trust before you say yes to the extra shift—not a perfect tax forecast. Gross first, withholdings second, decision third. That order keeps overtime from feeling larger on the schedule than it will feel in the bank.


