UK timesheet calculator

How to calculate timesheet hours and pay

1. Choose your dates and confirm the time zone where you worked. A reporting period can contain more than one overtime workweek.
2. Enter each shift's start and finish. Check AM/PM in 12-hour view. Overnight finishes show Next day; use Change finish day to correct it. Use More to add another shift.
3. Enter only unpaid off-duty breaks. Paid breaks stay in your worked hours.
4. Add an hourly rate if you want a gross pay estimate. Use your contract's overtime terms if they apply.
5. Review any errors or missing workweek information, confirm completed weeks, then save or export your result.

Weekly, fortnightly or monthly timesheets

Choose a weekly period for seven days or fortnightly for two weeks. For a monthly timesheet, choose the month; use custom dates for another range. Leave days off blank. Your totals include every entered shift in that period, while weekly overtime is worked out one workweek at a time.

Estimate UK overtime pay

UK overtime does not have a universal 40-hour threshold or time-and-a-half rate. Your employment contract usually explains any overtime pay and how it is worked out. Read GOV.UK overtime guidance.

The calculator starts with no overtime premium. If your contract uses a weekly threshold, enter that threshold and the agreed overtime rate or multiplier. Weekly thresholds still apply separately when you view a fortnight or month.

Select Choose by shift under Overtime to enter agreed standard, time-and-a-half, double-time or custom premiums. Use Normal + overtime when a rate changes during a shift. Allocate the hours after unpaid breaks, in the order worked. These are total agreed rates; weekly overtime is not added on top. Automatic daily rules, annualised hours, time off in lieu, different basic job rates and automatic night or weekend schedules are outside this version. Use the hours total if the supported pay settings do not match your arrangement. This tool does not check minimum-wage or working-time compliance.

Hours, unpaid breaks and overnight work

Minutes are not decimal hours

Divide minutes by 60 to convert them: 15 minutes is 0.25 hours, 30 minutes is 0.50 and 45 minutes is 0.75. The calculator keeps the underlying minutes for calculation. A rounded decimal display does not determine your pay.

Calculate hours with an unpaid lunch break

A break entitlement does not tell you whether the break is paid. That depends on your contract. Do not deduct a paid break or time you remained on duty. GOV.UK explains rest breaks at work.

For a 30-minute unpaid lunch, select 30 min under Unpaid break. To record several breaks, open More and add their start and finish times. Use the duration or the timed breaks for the same unpaid time, so it is deducted once.

Most adult workers are entitled to an uninterrupted 20-minute rest break when working more than six hours. That break need not be paid. This calculator records the unpaid time you enter; it does not assess rest-break entitlement.

Calculate an overnight shift

A shift from 22:00 to 06:00 the following day is eight hours before breaks on an ordinary night. A clock change can alter the elapsed time. Keep the workplace time zone and choose the correct occurrence if a time happens twice. In the UK, 22:00 on 24 October 2026 to 06:00 on 25 October spans the autumn clock change: nine hours before breaks. Starting at 22:00 on 25 October instead gives eight hours.

With Basic pay only or Choose by shift, the whole shift counts on its starting date, even if it finishes after your report ends. Weekly overtime instead follows the actual workweek boundaries. In weekly mode, use timed breaks for a shift crossing a week or reporting boundary, and add any outside hours requested.

Basic pay and chosen shift rates include the whole shift on its starting date. Weekly overtime includes only hours inside your report dates, using the actual workweek boundaries.

Download your timesheet for Excel or PDF

Copy a completed shift into empty weekdays, with Undo if you need it. Existing shifts are kept. Save periods on this device, reopen them and copy a schedule into new dates. Add an optional report name and note beside the download controls. CSV downloads and browser printing are free, with no email required.

The main CSV opens in Excel and shows shift hours, pay, rate multipliers such as 1.0×, 1.5× and 2.0×, and a total. Split shifts show how many hours use each rate. Weekly overtime is labelled separately; chosen shift premiums are shown as agreed rates. For exact minutes without totals, use Shift data CSV under Detailed exports. Choose Print or save PDF, then use your browser's printer or PDF destination. The export includes the calculation settings and any limitations shown with your result.

Use Actions → Copy hours to US to transfer your dates, times and breaks to the other calculator. Rates reset, and any existing draft is kept as a named copy. Check the new workplace time zone. Local saving is tied to this browser. Clearing browser data can remove it, and another person using this browser may be able to see it. Use the backup download for a separate copy, and restore it when needed.

Common questions

Explore your UK pay

Use your hours as a starting point to understand your hourly earnings, take-home pay and how your salary compares.