PublicSoftTools
Tools16 min read·PublicSoftTools Team·May 2026

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 typeStructureTotalsBest for
Weekly timesheetMonday–Sunday rows, start/end/break per dayDaily hours, weekly total, overtimeRegular employees on weekly pay or weekly overtime threshold
Bi-weekly timesheetTwo weeks of daily entriesPer-week and two-week totalsUS employers with bi-weekly payroll; allows tracking across two pay periods
Monthly timesheetDaily entries for all working days in a monthMonthly total hours and payMonthly salary workers; project-based billing by month
Project-based timesheetTasks/projects listed with hours per dayHours per project + totalFreelancers, consultants, agencies billing multiple clients
Multiple jobs timesheetSeparate row per job/client per dayPer-job and total hoursWorkers with multiple employers; checking total against 48-hour limit

How to Use the Timesheet Calculator

  1. Open the timesheet calculator.
  2. For each working day, enter your start time and end time. Leave blank for days off.
  3. Enter your break duration in minutes for each day (any unpaid breaks are deducted from the hours worked).
  4. Set your hourly rate to calculate estimated gross weekly pay.
  5. Set your overtime threshold (e.g., 40 h/week for US; 48 h/week for UK). Hours above this are flagged as overtime.
  6. 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:

Example: 7h 45min = 7.75 hours. Daily hours across the week are summed to give weekly total hours.

Common Timesheet Errors

Common errorExampleFix
Not subtracting unpaid breaksClocking 9:00–17:00 = 8 hours but with 1 hour unpaid lunch = 7 hours paidAlways enter break duration separately; the calculator deducts it from total hours
Midnight shift crossing22:00–06:00 → naively 06:00 − 22:00 = −16 hoursAdd 24 hours to the end time: 06:00 + 24:00 − 22:00 = 8 hours. The calculator handles this automatically.
Confusing gross and net hoursContract says 37.5 hours/week; that is hours worked, not hours at locationGross time = start to end; net time = gross − breaks. Always calculate pay on net hours worked.
Using 12-hour format inconsistentlyEntering 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 wageReceiving flat daily rate that works out below NMW per hour for overtime hoursCalculate 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:

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:

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:

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:

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