PublicSoftTools
Tools5 min read·PublicSoftTools Team·June 2026

Timesheet Calculator: Track and Total Work Hours Accurately

Timesheets get rejected, payroll gets delayed, and invoices get disputed — usually because of simple arithmetic errors that a timesheet calculator would have caught. This guide covers how to build an accurate weekly timesheet, calculate overtime, and present hours in the format your payroll system actually needs.

Weekly Timesheet: Day-by-Day Approach

The most reliable way to fill a timesheet is to log each day as a separate entry rather than estimating a weekly total from memory. Open the Hours Calculator and add one shift row per worked day. For each row, enter:

The running total at the bottom gives your weekly hours in both hh:mm and decimal format.

Timesheet Formats by Use Case

Use caseFormat neededExample
Payroll (salaried)Total hours per week, hh:mm37h 30m
Payroll (hourly)Decimal hours × rate37.50 × $22 = $825
Client invoice (hourly)Decimal hours per project12.25 hours @ $85/hr
Time-off accrualHours worked this period152 hours / month
Overtime calculationHours above 40 per week43.75 − 40 = 3.75 OT hours

Calculating Overtime Hours

In the US, federal law (FLSA) requires overtime pay at 1.5× the regular rate for hours worked beyond 40 in a workweek. Some states (California, for example) also require daily overtime for hours beyond 8 in a single day.

To calculate a week with overtime: add all daily hours using the calculator. If the total exceeds 40, the excess is overtime. Example: Mon–Fri totals to 44.5 hours. Regular hours = 40 × $20 = $800. Overtime = 4.5 × $30 = $135. Total gross = $935.

Freelancer Timesheets and Client Invoicing

Track time per project, not per day

If you bill multiple clients, run a separate calculator session per client project. Record each working block as its own shift row. The decimal total per project goes directly onto the invoice line item: 12.25 hours × $95/hr = $1,163.75.

What to include on a timesheet invoice

A billable timesheet should show: date worked, brief description of work performed, hours (decimal), rate, and line total. Many clients also require the start/end time per entry for transparency. The calculator gives you all of this — combine it with the Invoice Generator to produce a formatted PDF.

When clients dispute hours

The strongest defence against a disputed timesheet is contemporaneous records — notes made at the time of work, not reconstructed later. Keep a running log of start/end times in any app (even a notes app), then transfer to the calculator at invoice time. This is far more defensible than entering estimated totals from memory.

Common Timesheet Errors to Avoid

Entering clock-in time instead of actual start

If you clocked in at 9:02 but did not start work until 9:15 (grabbing coffee, settling in), the billable or reportable start is 9:15. Verify what your employer or client considers the start of billable time.

Using the wrong week boundary

The FLSA workweek starts on whatever day the employer designates — typically Sunday or Monday — and must be consistent. If your employer's week runs Tuesday to Monday, a shift crossing midnight Tuesday is split across two pay periods. Confirm the week boundary before calculating weekly totals.

Not accounting for schedule variations

Entering the same hours for every day is a red flag on timesheets. Even if your schedule is predictable, small variations in actual start/end times are normal and make records look genuine. Log actual times rather than scheduled times.

Build Your Timesheet Now

Add shifts day by day, see running totals in hh:mm and decimal. Free, no signup, no data stored.

Open Hours Calculator