How to fill in the time card
Pick the date your work week starts on; the seven rows below are then labelled with real dates. For each day, type the start and end of the shift in 24-hour format, so 10 pm is 22:00 and 6 am is 06:00, and enter the unpaid break in minutes. If you worked two separate blocks on the same day, such as a lunch shift and a dinner shift, add a second shift to that day. Leave a day empty if you did not work. Press Calculate to check every shift and total the week.
Only one time per shift is ever needed, so nothing depends on am or pm. A shift that crosses midnight must have ends next day ticked. The calculator does not guess: an end time earlier than the start is treated as a mistake and flagged, because "09:00 to 17:00" with a typo and a real overnight shift look the same to a computer.
How the weekly total is calculated
Each start and end is converted to minutes from the beginning of the week: the day number times 1,440, plus the clock time. Ticking ends next day adds another 1,440 minutes to the end. The shift length is end minus start and must be more than 0 and at most 24 hours; the unpaid break is then subtracted. The weekly total is the sum of these whole minutes, and only at the end is it divided by 60 to give decimal hours.
Summing minutes first matters. Adding up rounded decimal hours, such as 7.33 + 7.33 + 7.33 for three 7 h 20 min shifts, gives 21.99 hours instead of the correct 22.00. The CSV carries the decimals to four places and its total row is computed from the same integer minutes shown on screen.
Worked example: an overnight shift and a day shift
Week starting Monday 19 October 2026. On Monday the shift runs from 22:00 to 06:00 on Tuesday morning with a 30-minute break. From Monday 22:00 to Tuesday 06:00 is 480 minutes; minus 30 leaves 450 minutes = 7:30 = 7.50 hours. On Tuesday there is a day shift from 09:00 to 17:00 with a 45-minute break: 480 − 45 = 435 minutes = 7:15 = 7.25 hours. The Tuesday shift starts three hours after the overnight shift ended at 06:00, so there is no overlap. The week totals 885 minutes, or 14:45 and 14.75 decimal hours, across two shifts. Use Load example to see it.
Overlaps and other checks
Before totalling, every shift is compared with every other shift, including an overnight shift that runs into the next morning. If two shifts share any time, the total and the export are blocked and both shifts are named, so the same hours are never counted twice. Shifts that touch, such as 08:00–12:00 and 12:00–16:00, are fine. A row with only some fields filled in is also reported rather than ignored, so a missing end time cannot quietly drop a shift from your week.
Exporting the CSV
Export CSV downloads quantstock-time-card.csv with one row per shift: start date and time, end date and time, gross minutes, unpaid break minutes, net minutes and decimal hours, then a total row. Dates use the ISO format (2026-10-20) and decimals use a dot, which opens cleanly in Excel, Google Sheets and Numbers. The file is created in your browser; nothing is uploaded or stored by QuantStock, so keep the file or print the page if you need a record.
FAQ
How do I enter a night shift that ends after midnight?
Enter the real clock times, for example 22:00 and 06:00, and tick ends next day. The shift is counted on the day it started. To record a full 24-hour shift, enter the same start and end time and tick the box.
Are breaks paid or unpaid in this calculator?
The break field is for unpaid time only, in whole minutes, and it is subtracted from the shift. Leave paid breaks out of that field, since they are part of the hours worked. A break cannot be longer than the shift itself.
Is 7:30 the same as 7.30 hours?
No. 7:30 means seven hours and thirty minutes, which is 7.5 decimal hours. 7.30 decimal hours is only seven hours and 18 minutes. Payroll and invoices usually need decimal hours, so the calculator shows both: hours and minutes for reading, decimals for multiplying by a rate.
What happens to a shift that crosses into next week?
A shift that starts on the last day of the card and ends the next morning is counted in full in this week, on its start date. The CSV still shows the real end date. If your employer splits such shifts at midnight, adjust the hours yourself.
Does it handle daylight saving time, overtime or pay?
No. It uses wall-clock time, so a night when the clocks change is counted as if they had not. It does not apply overtime rules, rounding policies or pay rates, which depend on your contract and local law. Check payroll figures with your employer or the official rules where you work.
Need a single shift instead of a week? Use the hours between times calculator. If you sell your time, price an hour with the margin and markup calculator and see how many billable hours cover your costs with the business break-even calculator.