How to Calculate Hours on a Time Card (Manual + Excel)
Master how to calculate hours on a time card: subtract start from end, deduct unpaid lunch, convert minutes to decimals, then move the same logic into Excel formulas.
How to calculate hours on a time card is mostly arithmetic: end minus start, minus unpaid lunch, then convert leftover minutes to decimals. Online tools (Calculator.net, Calculator Soup, Harvest, Redcort) dominate this SERP because people want instant math. Excel still wins when you need a reusable biweekly archive you can print and file.
Pair this with the time card calculator excel hub when you are ready to automate punches.
Key takeaway: Net hours = (clock-out − clock-in) − unpaid break. Convert minutes÷60 to decimals (15→0.25, 30→0.50, 45→0.75). In Excel, encode the same rule as =(Out-In-Lunch)*24.
Manual Method (No Spreadsheet)
Example: In 9:00 AM, Out 5:00 PM, unpaid lunch 30 minutes.
- Elapsed clock time = 8:00.
- Subtract lunch 0:30 → 7:30 worked.
- Decimal = 7 + 30/60 = 7.5 hours.
Another check: 7:30 AM to 4:30 PM with 30-minute lunch → 9:00 elapsed − 0:30 = 8.5 hours.
Product highlight: 15 minutes = 0.25 hours · 30 minutes = 0.50 · 45 minutes = 0.75 — memorize these three and most cards finish faster.
Minutes ↔ Decimals Table
| Minutes | Decimal |
|---|---|
| 5 | 0.08 |
| 10 | 0.17 |
| 15 | 0.25 |
| 20 | 0.33 |
| 30 | 0.50 |
| 45 | 0.75 |
| 50 | 0.83 |
Round consistently with payroll policy (some round to nearest 6 or 15 minutes).
Moving the Same Logic Into Excel
- Store In/Out as Time values, not text.
- Store Lunch as 0.5 or
0:30(be consistent inside the formula). - Daily decimal hours:
=(C2-B2-D2)*24. - SUM days for the card total.
- For duration-style totals, some sheets use
[h]:mmwithout*24— pick one language and stay in it.
Overnight and Split Shifts
If Out appears earlier than In (10:00 PM → 6:00 AM), add one day to Out or use:
=IF(C2<B2,(C2+1-B2-D2)*24,(C2-B2-D2)*24)
Split shifts with multiple unpaid breaks: sum break minutes into one Lunch field or add Break2. Document which method your team uses.
Web Calculators vs Excel Files
Web calculators are perfect for a one-off check. Excel (or a structured workbook like Biweekly Time Card Calculator Excel) wins when you need period history, printable cards, and formulas you can audit. PlanoNest sells the workbook as a one-time purchase; pricing is on the product page only.
Frequently Asked Questions
How do I put 7 hours and 45 minutes on my timesheet?
Enter 7.75 decimal hours, or enter duration 7:45 if the sheet uses [h]:mm.
What is the formula to calculate hours?
Manually: end − start − break. In Excel: =(End-Start-Break)*24 for decimals.
How many hours is 7:30 to 4:30? Nine hours elapsed; subtract unpaid lunch to get net (e.g., 8.5 with a 30-minute lunch).
Does overtime include lunch? Usually no — unpaid meal periods do not count toward hours worked for OT thresholds. Confirm local rules.
Operating Notes for Accurate Cards
Enter times in a consistent format for the whole period — either 12-hour with AM/PM or 24-hour military — and lock the column format before the first punch. If someone types 830 instead of 8:30, Excel may store a number that looks fine until the daily total jumps by hundreds of hours. Spot-check the first day after you paste from paper cards.
Treat unpaid lunch as a first-class input. A card that only has Time In and Time Out silently overpays when meal periods are unpaid. Prefer a Lunch (hours) column or explicit lunch-out / lunch-in pairs. When a day has no meal break, leave the lunch field blank or zero — never hide the rule in a comment.
Before you send totals to payroll, reconcile one sample week against a known-good calculator or manual math. Confirm overnight shifts (out earlier than in) use a midnight-crossing adjustment. Keep paper or PDF copies of signed cards when your process still requires wet signatures; the spreadsheet is the calculator, not always the legal archive.
Final Review Pass
Open Print Preview with a realistic biweekly card filled in. Confirm Time columns still look like times, Total Hours show decimals (or [h]:mm if you chose duration format), and period totals are not clipped off the page. Prefer PDF for the signed handoff; keep the .xlsx as the editable master. Never paste a fixed PlanoNest product price into the sheet header — live pricing stays on the product page.
Recordkeeping Habits That Prevent Payroll Surprises
Number each pay period clearly (for example 2026-W27–W28) and never reuse a period label after you lock totals. When a punch is corrected, note the reason in a Comment or Notes column instead of silently overwriting history. Store only what payroll needs — employee name, dates, in/out, breaks, totals — not unrelated HR fields that belong on a separate roster template. These habits matter more than fancy borders when a total is questioned later.
Worked Examples You Can Recreate
Example A — Standard day. In 8:00 AM, Out 4:30 PM, lunch 30 minutes. Elapsed = 8.5 hours. Net = 8.0 hours. Decimal on the card: 8.00.
Example B — Short lunch. In 9:15 AM, Out 5:45 PM, lunch 15 minutes. Elapsed = 8.5. Net = 8.25 (8:15 worked).
Example C — Overnight. In 10:00 PM, Out 6:00 AM next day, lunch 0. Elapsed = 8.0. In Excel, add one day to Out or use the IF overnight pattern so the subtraction does not go negative.
Example D — Two unpaid breaks. In 7:00 AM, Out 4:00 PM, breaks totaling 45 minutes. Net = 8.25. Enter 0.75 in Lunch or split into Break1/Break2 that sum inside the formula.
Walk each example on paper first, then encode it in Excel. If the spreadsheet disagrees, the bug is almost always formatting or a missing lunch field — not mysterious “Excel math.” When you later introduce overtime helpers, feed them these net decimals only. Gross elapsed time belongs in Notes if you need an audit of presence, not in the payroll hour column.
Operating Notes for Accurate Cards
Enter times in a consistent format for the whole period — either 12-hour with AM/PM or 24-hour military — and lock the column format before the first punch. If someone types 830 instead of 8:30, Excel may store a number that looks fine until the daily total jumps by hundreds of hours. Spot-check the first day after you paste from paper cards.
Treat unpaid lunch as a first-class input. A card that only has Time In and Time Out silently overpays when meal periods are unpaid. Prefer a Lunch (hours) column or explicit lunch-out / lunch-in pairs. When a day has no meal break, leave the lunch field blank or zero — never hide the rule in a comment.
Before you send totals to payroll, reconcile one sample week against a known-good calculator or manual math. Confirm overnight shifts (out earlier than in) use a midnight-crossing adjustment. Keep paper or PDF copies of signed cards when your process still requires wet signatures; the spreadsheet is the calculator, not always the legal archive.
Final Review Pass
Open Print Preview with a realistic biweekly card filled in. Confirm Time columns still look like times, Total Hours show decimals (or [h]:mm if you chose duration format), and period totals are not clipped off the page. Prefer PDF for the signed handoff; keep the .xlsx as the editable master. Never paste a fixed PlanoNest product price into the sheet header — live pricing stays on the product page.
Recordkeeping Habits That Prevent Payroll Surprises
Number each pay period clearly (for example 2026-W27–W28) and never reuse a period label after you lock totals. When a punch is corrected, note the reason in a Comment or Notes column instead of silently overwriting history. Store only what payroll needs — employee name, dates, in/out, breaks, totals — not unrelated HR fields that belong on a separate roster template. These habits matter more than fancy borders when a total is questioned later.
Related reading
- Habit trackers collection
- Time card calculator excel hub
- Time Card Calculator Excel: Auto-Total Hours Without Payroll Guesswork
- Biweekly Time Card Calculator Excel: 14-Day Hour Totals That Match Payroll
- How to Make a Time Card in Excel (Step by Step)
- Time Card Calculator With Lunch Break: Excel Formulas That Deduct Meals
- Time Card Template Excel: Pick a Calculator Layout That Prints Clean
