Free calculator
Time card calculator
Total a Monday–Sunday week from clock in, clock out, and unpaid break minutes per day. See each day and the week in hours:minutes and decimal hours (common for payroll exports). Optionally multiply by an hourly rate for a gross illustration only. For date-to-date duration or H:MM duration math without a weekly grid, use our separate time calculator—linked below.
When to use this calculator
Quick weekly hour totals before you paste the same structure into Sheets or Excel—transparent math, not a timeclock product.
- Rough-check stamped hours minus an unpaid lunch or other off-clock break.
- See the week in decimal hours side by side with h:mm for forms that ask for decimals.
- Ballpark gross pay for the week from decimal hours × rate—then hand the result to payroll with your real rules.
- Pair with the time calculator when you need elapsed time between two instants instead of a week grid.
For each row with both start and end, we take the minute-of-day difference, subtract unpaid break minutes (capped at the gross span), and add the day to the week.
Same-day clock span
End must be later than start on the same calendar day. If either field is blank, that day contributes 0 minutes.
Unpaid break
Break minutes reduce gross minutes for that day. If break exceeds the span, we cap it so net does not go negative.
Decimal hours
Decimal hours are worked minutes ÷ 60 rounded to 2 decimal places for display—common for exports, though your employer may use different rounding.
We do not model overnight shifts that cross midnight, multiple in/out segments per day, or statutory break auto-rules.
Need elapsed time or H:MM math without this week grid? Use the time calculatorinstead.
Only need one day? The work time calculator gives a fast single shift with the same break math as one row here.
Google Sheets & Excel
Treat start and end as time-of-day values (not text) so subtraction gives a duration. Break can be minutes divided by 1440 (minutes per day) or TIME(0, breakMin, 0).
=(end-start)*24-(breakMin/60)With start/end as times on the same calendar date, end−start is a fraction of a day; multiply by 24 for hours. Subtract breakMin/60 when break is stored in minutes.
=SUM(decimalHourRange)Build decimal hours per day (for example =(B2-A2)*24 − C2/60) in one row each, then SUM the column. Format totals as Number, not Time, when you want 7.5 style decimals.
Frequently asked questions
How is this different from your time calculator?
This page is a weekly time card grid: in, out, break, then totals. The time calculator covers duration between two date-times, shifting a date-time by an offset, and adding or subtracting H:MM durations—different jobs. Pick the tool that matches your wording.
How do you get decimal hours from a time card?
Convert worked minutes to hours as minutes ÷ 60. Example: 7 h 30 m → 450 minutes → 7.50 decimal hours. This page rounds the decimal display to 2 places.
How much is 15 minutes in decimal hours?
15 minutes is 0.25 hours (because 15 ÷ 60 = 0.25). 30 minutes is 0.50; 45 is 0.75.
Does break time reduce my total?
Yes—unpaid break minutes you enter are subtracted from end − start for that day, up to the gross span. Paid breaks are not modeled separately; you can fold them into your own assumptions.
What if my shift crosses midnight?
This v1 tool expects end after start on the same calendar day. For overnight work, split the hours across days in your own policy or use a spreadsheet model—midnight crossing is not built in here.
Can I submit this to payroll?
Treat this as a check and a teaching aid. Payroll systems have their own rounding, overtime, and compliance rules. Always follow your employer’s official process and records.
Do you calculate overtime automatically?
No. Overtime thresholds and premiums depend on law, contract, and employer. We show straight worked hours from your inputs only—use HR guidance for OT.
How do I match a day in Google Sheets or Excel?
Store start and end as time values. Net decimal hours for one day can follow =(end-start)*24-(breakMin/60) when breakMin is whole minutes—see the copy cards on this page.
Why might decimals differ from my employer’s portal?
Employers often round punches to the nearest minute, 5, 6, or 15 minutes, or use two decimal rules. We use a simple 2-decimal display from exact minute math here—expect differences until rules match.
Is this labor-law or compliance advice?
No. It is a free math helper. Break laws, recording duties, and overtime depend on your jurisdiction and contract—ask qualified professionals or HR.