Timesheet Calculator — Calculate Total Hours Worked for the Week or Month
Timesheets serve multiple purposes: payroll calculation, client billing, productivity tracking, and compliance with employment legislation. Whether you are an employee checking your payslip, a freelancer billing clients, or a manager approving hours, accurate timesheet calculations matter. The timesheet calculator on PublicSoftTools handles daily entries with breaks across an entire week or month, calculating totals, overtime, and estimated pay.
Timesheet Types
| Timesheet type | Structure | Totals | Best for |
|---|---|---|---|
| Weekly timesheet | Monday–Sunday rows, start/end/break per day | Daily hours, weekly total, overtime | Regular employees on weekly pay or weekly overtime threshold |
| Bi-weekly timesheet | Two weeks of daily entries | Per-week and two-week totals | US employers with bi-weekly payroll; allows tracking across two pay periods |
| Monthly timesheet | Daily entries for all working days in a month | Monthly total hours and pay | Monthly salary workers; project-based billing by month |
| Project-based timesheet | Tasks/projects listed with hours per day | Hours per project + total | Freelancers, consultants, agencies billing multiple clients |
| Multiple jobs timesheet | Separate row per job/client per day | Per-job and total hours | Workers with multiple employers; checking total against 48-hour limit |
How to Use the Timesheet Calculator
- Open the timesheet calculator.
- For each working day, enter your start time and end time. Leave blank for days off.
- Enter your break duration in minutes for each day (any unpaid breaks are deducted from the hours worked).
- Set your hourly rate to calculate estimated gross weekly pay.
- Set your overtime threshold (e.g., 40 h/week for US; 48 h/week for UK). Hours above this are flagged as overtime.
- The calculator shows daily hours, weekly total, overtime hours, and estimated pay — with a summary card you can save or print.
How Timesheet Hours Are Calculated
For each working day:
Net hours = (End time − Start time) − Break duration
Example: Start 8:45, End 17:30, Break 45 min. Raw hours = 17:30 − 8:45 = 8h 45min. Break deduction: 45 min. Net hours = 8h 45min − 0h 45min = 8h 00min = 8.00 hours.
For time calculations, it is convenient to convert to decimal hours:
- 15 minutes = 0.25 hours
- 30 minutes = 0.50 hours
- 45 minutes = 0.75 hours
Example: 7h 45min = 7.75 hours. Daily hours across the week are summed to give weekly total hours.
Common Timesheet Errors
| Common error | Example | Fix |
|---|---|---|
| Not subtracting unpaid breaks | Clocking 9:00–17:00 = 8 hours but with 1 hour unpaid lunch = 7 hours paid | Always enter break duration separately; the calculator deducts it from total hours |
| Midnight shift crossing | 22:00–06:00 → naively 06:00 − 22:00 = −16 hours | Add 24 hours to the end time: 06:00 + 24:00 − 22:00 = 8 hours. The calculator handles this automatically. |
| Confusing gross and net hours | Contract says 37.5 hours/week; that is hours worked, not hours at location | Gross time = start to end; net time = gross − breaks. Always calculate pay on net hours worked. |
| Using 12-hour format inconsistently | Entering 7:30 for 7:30 PM (should be 19:30) | Use 24-hour time throughout or ensure AM/PM is selected correctly for 12-hour format inputs |
| Not checking weekly total against minimum wage | Receiving flat daily rate that works out below NMW per hour for overtime hours | Calculate effective hourly rate (total pay ÷ total hours). Must be at or above NMW for all hours worked. |
Timesheet for Freelancers and Contractors
For freelancers billing clients, a timesheet does double duty — it records hours for pay calculation and provides the basis for invoicing. Best practices:
- Track time at the task or project level, not just daily totals
- Record time in real time rather than reconstructing from memory at week's end
- Note the specific work done (brief description) alongside hours for invoice line items
- Keep timesheets for at least 5 years for HMRC self-assessment purposes
- Distinguish billable hours (charged to client) from non-billable (admin, learning, business development)
The invoice generator allows you to turn timesheet totals directly into a professional invoice.
Timesheet Compliance Requirements
UK employers must keep working time records under the Working Time Regulations 1998, specifically to demonstrate compliance with the 48-hour average weekly limit. Workers who have opted out of the 48-hour limit still have their hours recorded to monitor compliance with other provisions (daily/weekly rest, night worker limits).
Minimum record-keeping requirements for employers:
- Records of workers who have signed a 48-hour opt-out
- Working time records demonstrating compliance (especially for night workers)
- Holiday records (to prove statutory minimum leave is being provided)
- Records must be retained for 2 years after the period they cover
For HMRC purposes (minimum wage compliance), employers must retain pay and working time records for 3 years.
Overtime on Timesheets
Overtime handling in UK employment is determined by the employment contract — not by statutory law (unlike the US, where the FLSA mandates 1.5× for hours over 40/week for non-exempt workers).
UK overtime arrangements:
- Paid overtime at standard rate: Additional hours paid at the same hourly rate as regular hours — most common in UK
- Time and a half (1.5×): Extra hours paid at 150% of standard rate — common in manufacturing, healthcare, some hospitality
- Double time: Weekend or bank holiday overtime at 200% — common in some industries and contracts
- Time off in lieu (TOIL): Overtime compensated with equivalent paid time off rather than additional pay — common in public sector and professional services
- Unpaid overtime: Common in salaried roles; must still result in effective hourly pay at or above National Minimum Wage
Automated Time Tracking vs. Manual Timesheets
Manual timesheets (completed at the end of each day or week) introduce memory-based errors and take time to complete. Alternatives:
- Timer apps: Start/stop timers when switching tasks; automatically log time. Examples: Toggl, Clockify (free tier), Harvest.
- Integrated systems: Some project management tools (Jira, Asana, Monday.com) have time tracking built in.
- Clocking-in systems: Physical card swipe, biometric, or phone-based clock-in for employers who need precise attendance records.
For most individuals, the timesheet calculator provides what is needed for payroll or invoicing purposes without software subscriptions.
Common Questions
Do I need to record my hours if I am a salaried employee?
Your employer is required to keep records sufficient to demonstrate Working Time Regulations compliance (particularly the 48-hour week average). As an individual, keeping your own records is advisable if you regularly work long hours — to verify your working time, support any employment tribunal claims, or demonstrate that unpaid overtime is being worked (relevant if seeking a pay review or raising a concern about conditions).
How do I handle rounding time on a timesheet?
For payroll purposes, most employers round to the nearest 15 minutes or 6 minutes (0.1 of an hour). If your contract specifies rounding, apply that consistently. Rounding must not systematically favour the employer — rounds up and rounds down should average out over time. The timesheet calculator shows exact hours; apply rounding manually if required by your employer's policy.
What is the difference between a timesheet and a time card?
These terms are often used interchangeably. A time card traditionally refers to the physical card punched by a clock-in machine, showing exact arrival and departure times. A timesheet is a more comprehensive record — it may cover multiple days, projects, or tasks, and typically includes break deductions and total hours. Both serve the same fundamental purpose: documenting time worked for payroll and compliance.
Calculate Your Timesheet
Enter daily start and end times across a week to calculate total hours worked, overtime, and estimated pay.
Open Timesheet Calculator