Payroll hours calculator for small teams
Add clock-in and clock-out times, unpaid breaks and hourly rates to calculate worked hours and estimated gross pay before payroll. Built for small businesses still using spreadsheets, paper notes or manual timesheets.
Example shift
Overnight close
Clock in
22:00
Clock out
02:00
Calculated result
Worked hours
4.00
At £13/hr
£52
Gross pay estimate only. Payroll rules are handled elsewhere.
Free calculator
Calculate payroll hours from clock-in and clock-out times
This calculator is a practical timesheet helper. It estimates worked hours and gross pay from the information you enter. It does not calculate tax, National Insurance, pensions, holiday pay, overtime rules or legal payroll obligations.
For actual payroll, check your records and payroll provider before submitting final pay.
Total worked hours
0.00
Estimated gross pay
Add rates
Ready rows
0
Shift entry
Add times, breaks and an optional hourly rate.
- Add a clock-in time.
- Add a clock-out time.
Summary table
Only rows without validation errors are included in totals and exports.
| Staff | Date | Shift | Break | Worked hours | Estimated gross pay |
|---|---|---|---|---|---|
| Add valid clock-in and clock-out times to see calculated rows here. | |||||
Total hours
0.00
Estimated gross pay
Add rates
Rows included
0
Manual payroll prep
When manual payroll hours get messy
Manual payroll hours get messy when clock records, breaks, corrections and rates live in different places. A quick calculator helps with one check, but recurring payroll prep needs a cleaner workflow.
Clock records live in different places
One person has notes, another has a spreadsheet, and the final total gets rebuilt by hand.
Breaks are deducted manually
Unpaid breaks need checking row by row before totals are trusted.
Overnight shifts confuse spreadsheets
A finish time after midnight can turn simple formulas into exceptions.
Corrections arrive by message
Forgotten clock-outs and shift changes often arrive after the rota was published.
Payroll hours are rebuilt weekly
Managers spend payroll prep time reconciling rows instead of reviewing exceptions.
No one knows which version is final
The final timesheet needs a clear reviewed state before payroll is submitted.
Basic formula
How to calculate staff hours for payroll
Keep it operational: calculate hours from reliable records, then check exceptions before sending figures to payroll.
Record the start and finish time for each shift.
Treat a finish earlier than the start as an overnight shift.
Subtract unpaid break minutes from the shift length.
Add worked hours across the payroll period.
Multiply by hourly rate only when you need a gross pay estimate.
Review missing clock records and corrections before payroll.
Temporary fix
Why calculators are only a temporary fix
A calculator helps with a quick check when you need to verify a shift, break deduction or gross pay estimate.
If managers calculate every week from messages, screenshots or spreadsheets, the workflow is doing too much by hand.
Weekola connects rotas, attendance and timesheets so hours are easier to review before payroll.
Connected workflow
How Weekola makes payroll prep cleaner
Weekola helps small teams prepare cleaner timesheets by connecting rotas, attendance and payroll-prep workflows. It is payroll prep software, not a full payroll engine.
Rota
The expected shift record shows who was meant to work and when.
Attendance
Clock-in and clock-out records show what actually happened.
Timesheets
Reviewed period totals are easier to check before payroll.
Shift swaps
Approved assignee changes stay visible before hours are reviewed.
Leave
Approved absence is visible before scheduling decisions are made.
Team records
Staff details sit behind the hours instead of in separate notes.
Related links
Keep going from the calculator
Common questions
Payroll hours calculator FAQ
- How do I calculate staff hours for payroll?
- Record each shift's start and finish time, account for overnight shifts, subtract unpaid breaks, then add the worked hours across the payroll period. Review exceptions before sending final figures to your payroll provider.
- How do I calculate an overnight shift?
- If the clock-out time is earlier than the clock-in time, treat the finish as the next day. For example, 22:00 to 02:00 is 4 hours before any unpaid break is deducted.
- How do I subtract unpaid breaks from worked hours?
- Calculate the total time between clock-in and clock-out, then subtract the unpaid break minutes. The break cannot be longer than the shift time.
- Can this calculator estimate gross pay?
- Yes. Add an optional hourly rate and the calculator will multiply worked hours by that rate to estimate gross pay for the row and total period.
- Does this calculate tax or National Insurance?
- No. The calculator estimates worked hours and gross pay only. It does not calculate tax, National Insurance, pensions, holiday pay, overtime rules or legal payroll obligations.
- Is this a replacement for payroll software?
- No. It is a practical timesheet helper for checking hours and gross pay estimates before payroll. Use your payroll provider or accountant for final payroll processing.
- What if staff forget to clock out?
- Flag the row, check the rota, ask the manager or employee to confirm the finish time, and keep a note of the correction before using the hours for payroll prep.
- How can I avoid spreadsheet timesheet errors?
- Keep clock records, corrections and reviewed totals in one workflow, avoid copying totals between files, and review exceptions before payroll. Weekola helps by connecting rotas, attendance and timesheets.
- Can Weekola turn attendance into timesheets?
- Yes. Weekola helps small teams prepare cleaner timesheets by connecting attendance records with rota-linked workflows for review before payroll.
- Is Weekola suitable for small teams?
- Yes. Weekola is built for small shift-based teams that need rota, attendance, timesheet, shift swap and leave workflows without a heavyweight HR suite.
Weekola
Stop rebuilding payroll hours by hand
Replace manual timesheet checking with rota-linked attendance, clearer review and payroll-ready records for small teams.