Sheetsmith

Time and a Half Calculator

Your hourly rate, your normal hours and your overtime hours — see what time and a half (or double time) pays, and your total for the week.

1.5× · 2× · customWeekly totalOvertime hourly rateNothing uploaded

Calculator

Overtime hourly rate£18.75
Normal pay£500.00
Overtime pay£112.50
Total this week£612.50

Need to work out the hours first from start and finish times? Use the overtime calculator.

Overtime Calculator Excel template

Different rates for different people?

This is one rate, one multiplier. The Overtime Calculator template holds business defaults, per-role rules and per-employee overrides, so a timesheet for a whole team comes out right for every contract.

  • Settings → Roles → Employees, blank means inherit
  • Timesheet looks up each person's thresholds and multipliers
  • Weekly summary splits regular, 1.5× and 2×
  • Excel, Google Sheets, LibreOffice — no macros
£7 Get the overtime template

Instant download · Excel, Google Sheets, LibreOffice · No macros

What time and a half means

"Time and a half" is an overtime rate of 1.5 times your normal hourly pay. At £12.50 an hour, time and a half is £18.75 an hour, so six overtime hours pay £112.50 on top of your normal week. "Double time" is twice the normal rate — £25.00 an hour in the same example — and is typically reserved for Sundays, bank holidays or hours beyond a second threshold. Some contracts use time and a quarter (1.25×) for the first few hours of overtime. The multiplier only applies to the overtime hours; normal hours are paid at the normal rate, which is why the calculator keeps the two separate.

Is time and a half a legal right in the UK?

No. Unlike some countries, UK law sets no overtime premium. What you are paid for extra hours is whatever your contract says — it may be time and a half, it may be your normal rate, it may be time off in lieu. Two legal floors still apply: your average pay across all hours worked in a pay period must not fall below the National Minimum Wage, and you cannot be made to work more than 48 hours a week on average (over 17 weeks) unless you've opted out in writing. If you're checking a payslip against this calculator and it's short, the contract and the rota are the documents to compare.

Salaried staff

Salaried employees often have no overtime rate at all: extra hours are "part of the job" up to a point, and beyond it some employers pay a flat overtime rate derived from the salary (annual salary ÷ 52 ÷ contracted weekly hours gives the hourly equivalent). Type that hourly figure into the calculator if you want to see what a given multiplier would pay.

Holiday pay and overtime

Overtime that is regular enough to count as normal pay must be included when your holiday pay is calculated, following a series of UK tribunal decisions. Purely voluntary, occasional overtime generally isn't. This calculator doesn't attempt that calculation; it's mentioned because it's the most common follow-up question.

Questions

How do I calculate time and a half?

Multiply your hourly rate by 1.5 to get the overtime hourly rate, then multiply by the overtime hours. £12.50 × 1.5 = £18.75; 6 hours × £18.75 = £112.50.

What is time and a half of £11.44?

£17.16 per hour. Double time would be £22.88.

Does the calculator handle daily and weekly thresholds?

Not this one — it takes overtime hours as given. The overtime calculator on this site works the hours out from shifts and thresholds, and the Excel template does it per employee.

Related tools