Hours & Time Card Calculator
This time card calculator adds multiple shifts and subtracts unpaid breaks to produce total working hours. Enter one shift per line with start time, end time, and break minutes; an end time earlier than its start is treated as the following day.
By Dr. Hassan Khames EliwaLast updated
Result
- Net time
- 15 hours, 30 minutes
- Gross hours
- 16.5000
- Unpaid break minutes
- 60
Shift breakdown
| Shift | Start | End | Break minutes | Net hours |
|---|---|---|---|---|
| 1 | 09:00 | 17:30 | 30 | 8.0000 |
| 2 | 22:00 | 06:00 | 30 | 7.5000 |
How it works
Keep the arithmetic in minutes
Each line uses three comma-separated entries: start,end,break. Times must use the 24-hour HH:MM format, such as 09:00 or 22:15. Breaks must be whole minutes, including an explicit zero when there is no unpaid break. Blank lines are ignored, and the calculator accepts up to 366 shifts in one calculation.
The tool converts each clock time to minutes after midnight. It subtracts start from end, adding 1,440 minutes only when the end is earlier. It then deducts that line's unpaid break. Net minutes are summed before conversion into decimal hours, so the total is not built from rounded row values.
What the totals mean
Gross hours describe the full span between clock-in and clock-out. Net hours remove the breaks you entered. The hours-and-minutes result expresses that same net total without decimal notation. Four decimal places in the hours display help reconcile short shifts, but they do not create additional precision beyond the whole-minute inputs.
This is a duration worksheet, not a payroll rules engine. It does not decide whether breaks should be paid, apply overtime thresholds, round punches, detect duplicate shifts, or allocate work between calendar dates. Two identical start and end times mean zero elapsed minutes, not a full day. A single line cannot represent a shift lasting 24 hours or longer.
Worked example
A day shift followed by an overnight shift
Enter 09:00,17:30,30 on the first line and 22:00,06:00,30 on the second. The first span is 510 minutes, less 30 unpaid minutes, leaving 480 minutes. The overnight span is 480 minutes because the end is the next morning; its break leaves 450 minutes.
Together these shifts have 16.5000 gross hours and 60 unpaid break minutes. Net work is 930 minutes: the headline reads 15.5000, and the clock-style total reads 15 hours, 30 minutes. The shift table shows 8.0000 and 7.5000 net hours respectively.
A separate overnight check
For 23:15,07:00,45, the gross span is 465 minutes, or 7.7500 hours. Deducting 45 minutes leaves 420 minutes. Results are 7.0000 net hours, 7 hours, 0 minutes, 7.7500 gross hours, and 45 unpaid break minutes. This is a useful cross-check when a late start crosses midnight without crossing a full calendar day of work.
Expert tips
Common mistakes
- Reading decimal hours as clock minutes. A result of 7.5 hours means seven hours and thirty minutes, not seven hours and five minutes. Use the accompanying hours-and-minutes total when preparing a human-readable timesheet.
- Using an earlier end time to repair a typo. A line from 17:00 to 09:00 is accepted as an overnight span. Review that assumption rather than expecting the calculator to know which times were intended.
- Entering a break longer than the shift. That produces a validation error instead of negative work. If the entire span was unpaid, enter a break equal to the span; if no attendance occurred, remove the line.
Frequently asked questions
Can I paste a whole week of shifts?
Yes. Paste one start,end,break line for each shift, up to 366 nonblank lines. Keep headings and employee names outside those input lines.
Does it calculate overtime pay?
No. It totals durations only. Overtime eligibility, workweek boundaries, premiums, and applicable employment rules require a separate review.
What happens during a daylight-saving change?
The calculator uses clock readings without dates or time zones. For a shift spanning a clock change, establish actual elapsed time from a dated record before using the total for payroll.
Can I enter seconds or a fractional break?
No. Clock entries stop at whole minutes, and breaks must be whole nonnegative minutes. Resolve any seconds-based rounding under the policy governing your record.
Why is an equal start and end not 24 hours?
Identical clock readings are defined as zero here to avoid silently creating a full workday. Split longer attendance into clearly documented shorter periods instead.
Related calculators
Related guides
MathPercentages people get wrong: change, difference and pointsThe denominator determines the answer. Learn to distinguish percentage change, symmetric difference and percentage-point movements.14 November 2026 · 7 min read
MathStandard deviation without the jargonThe average tells you the centre. Standard deviation helps describe the spread, provided you know what the data represents.14 November 2026 · 7 min readAbout the author
Dr. Hassan Khames Eliwa holds a PhD in Construction & Built Environment and has more than 20 years of international project controls experience. He is Director of Eliwa Project Controls Limited in Auckland and founder of PMMilestone.org and PMMilestone.com.
Buy me a coffee