Timesheet hours total

The timesheet hours total calculator adds worked time across a list of clock-in and clock-out records, subtracts the unpaid break entered for each shift, and returns a clear net total. Every ISO datetime must include either Z or an explicit offset, so records from different offices, daylight-saving periods, or overnight schedules are compared on one UTC timeline. The result also shows gross hours, total break minutes, and the number of shifts included, making the calculation easy to review or automate.

Enter complete, unambiguous shift records

Provide one row for every continuous work period. The offset is essential because a local wall-clock time alone does not identify one instant during timezone changes. Decimal break minutes are accepted, which is useful when a source system records fractions of a minute.

A clock-out may fall on the next calendar day, so overnight work needs no special mode. The calculator rejects impossible dates, missing offsets, clock-outs that are not later than clock-ins, negative breaks, and breaks longer than their shift. It also rejects overlapping shifts after UTC normalization, because counting both would silently inflate the total.

Keeping every row explicit makes the input auditable and avoids assumptions about lunch policies, rounding rules, or which gaps between shifts should count as breaks.

Understand the UTC calculation

Each timestamp is parsed as a Gregorian calendar value and converted to a UTC millisecond position using its written offset. The calculation does not consult the machine timezone, a timezone database, the current date, or any external service. For each valid row, gross duration equals the UTC clock-out instant minus the UTC clock-in instant.

The entered break duration is converted from minutes to milliseconds and subtracted from that row's gross duration. Gross durations and break durations are then summed independently before the final net total is produced. This order gives stable results for teams whose entries use different offsets and for a shift that crosses midnight.

Hour and minute values are rounded only at the output boundary to six decimal places; the internal accumulation remains in integer milliseconds.

Use the result in payroll and reporting workflows

The returned fields separate source activity from the final payable duration, which helps a reviewer reproduce the arithmetic. The capability deliberately does not apply overtime bands, paid-break rules, wage rates, schedule tolerances, or employer-specific rounding. Those policies vary by agreement and jurisdiction, so they should be applied in a later, clearly documented step.

For repeatable imports, preserve the original ISO strings and offsets alongside the returned summary so any disputed total can be traced back to the exact instants and deductions used.