Skip to the tool
Priostack Apps

Timesheet and billable hours calculator

Add up your hours by day, week and client, then export them to bill.

Timesheet

Used for any client without a rate of their own. Leave blank to count hours only.

£
Currency

Amounts are worked out in this currency; nothing is converted.

Each billable row is rounded on its own; the hours worked stay exact.

No shifts yet.

Options

Used to count the hour gained or lost on the nights the clocks change. Pick 'no clock changes' if yours never change.

No client rates: the default hourly rate applies to every shift.

Hours billed

—

Add a complete shift (date, start and finish) to see the totals.

Hours worked
—
Non-billable time
—
Amount (excl. VAT)
—

Totals by client, week and day

No totals by client yet.

No totals by week yet.

No totals by day yet.

Clear all shifts?

Every shift on the sheet will be deleted from this device. Your settings and client rates are kept. To keep the shifts, export them to CSV first.

How it works

Log each shift with its date, start and finish times, break and client. The calculator adds up the time worked per day, per week (Monday to Sunday) and per client, shows every duration in hours and minutes and as decimal hours, and works out what to bill at your hourly rate or a client's own rate. Your rows stay on your device; the CSV export opens in Excel, Numbers or Google Sheets.

Enter a shift

One row per stretch of work. If the finish time is earlier than the start, say 22:00 to 06:00, the shift ends the next day and counts in full on the day it starts.

Take off breaks

Enter the break in minutes and it comes off the shift. A shift that overlaps another one is flagged, so the same hour is never counted twice.

Set your rates

The default hourly rate applies to every billable row; a client's own rate replaces it. With no rate, hours are counted but not priced. Untick 'billable' for internal time such as admin, sales or training.

Bill in 6- or 15-minute units

If you bill in units, choose one (6, 15 or 30 minutes, for example) and whether to round up or to the nearest. Each billable row is rounded on its own, and the time actually worked stays alongside.

Export

The CSV file uses commas and a decimal point and ends with a total row. Each row carries its ISO week, which makes pivot tables easy.

Time worked = finish − start − break (the finish is the next day if it is earlier than the start). Decimal hours = minutes ÷ 60, so 7 hours 45 minutes is 7.75 hours. Row amount = hours billed × hourly rate, rounded to the nearest penny (half a penny rounds up); every total adds up the rounded row amounts.

Example: two days on a contract

Monday 2 November 2026, 9:00 to 17:30 with an hour for lunch: 7 hours 30 minutes, or 7.50 hours. Tuesday 3 November, 9:00 to 12:15 with no break: 3 hours 15 minutes, or 3.25 hours. Week 45 total: 10 hours 45 minutes, or 10.75 hours. At £45 an hour that comes to £337.50 + £146.25 = £483.75 before VAT.

Frequently asked questions

How do I turn minutes into decimal hours?

Divide the minutes by 60: 15 minutes is 0.25, 30 is 0.50, 45 is 0.75 and 20 is about 0.33. The calculator shows each duration both ways and prices the exact minutes, not the rounded decimal.

Which day does a night shift count for?

The day it starts. A shift from Saturday 22:00 to Sunday 06:00 counts in full on the Saturday, and so in the week that contains that Saturday.

What happens when the clocks change?

Real time is counted. When the clocks went back at 2am on 25 October 2026, a shift from 22:00 on the 24th to 06:00 on the 25th lasted 9 hours, not 8. When they went forward at 1am on 29 March 2026, the same overnight shift lasted 7 hours.

Can I bill in 6-minute or 15-minute units?

Yes. Pick the unit and the rounding, and each billable row is rounded up, or to the nearest unit, on its own. Six minutes is a tenth of an hour, so 6-minute units always give a whole number of tenths.

Does it check breaks and working-time rules?

No, it adds up hours. For reference, workers aged 18 or over are usually entitled to one uninterrupted 20-minute break if they work more than 6 hours a day and to 11 hours' rest between working days, and can't work more than 48 hours a week on average (normally over 17 weeks) unless they opt out.

Is my data sent anywhere?

No. Everything is worked out in your browser and your rows stay on your device, unless you choose to save the timesheet to your Priostack account.

Sources

  1. GOV.UK: Rest breaks at work (13 March 2015)
  2. GOV.UK: Maximum weekly working hours (9 March 2015)
  3. GOV.UK: When do the clocks change? (24 November 2025)
  4. ISO 8601-1:2019, date and time representations (week numbering) (February 2019)
  5. IETF: RFC 4180, the CSV file format (October 2005)

This calculator helps you add up hours and amounts. It isn't legal, tax, employment or accounting advice: check your contract and the official guidance, or ask a professional.

Last reviewed: