Time Card Calculator
Type in your clock-in and clock-out times for each day. We add up the week, split regular hours from overtime at 40, and estimate your gross pay. Leave a day blank if you didn't work it.
| Regular hours | 40h 00m |
| Overtime hours (over 40) | 0h 00m |
| Regular pay | $800.00 |
| Overtime pay (1.5×) | $0.00 |
| Estimated gross pay | $800.00 |
Take this timesheet into Excel or Google Sheets
Manage your hours in a spreadsheet? Download this week two ways:
The formulas version keeps working after you download it: edit the start/end times in the sheet and the hours, overtime split and pay recalculate — using the same weekly 40-hour rule as this page. If a time cell opens as plain text, retype it like 9:00 AM so your spreadsheet treats it as a time.
Or paste the formulas into your own sheet (layout: A Day · B Start · C End · D Break minutes · E Hours · F Cumulative · G Regular · H Overtime · I Day pay; first day on row 2, hourly rate in B11)
=IF(OR(B2="",C2=""),0,ROUND(((C2-B2)+(C2<=B2))*24-D2/60,2))Hours for one day — clock-out minus clock-in, minus break, overnight-safe=MIN(E2,MAX(0,40-(F2-E2)))Regular hours — the part of today still under the week's 40 (F is the running total of E)=G2*$B$11+H2*$B$11*1.5Day pay — overtime is simply hours minus regular (E2−G2), paid at 1.5×Taxes are the one thing a single formula can't honestly do — federal withholding follows the IRS's multi-step Publication 15-T method, so for take-home pay use the Paycheck Calculator and bring the gross figure back to your sheet.
How it works
For each day, we take clock-out minus clock-in, subtract your unpaid break, and total the week. Following the federal FLSA weekly rule, the first 40 hours count as regular time and everything beyond that counts as overtime at 1.5× your rate. Overtime is counted in the order the hours were worked across the week, which is how most payroll systems do it.
Common questions
My state pays daily overtime. Is this still right?
This calculator uses the federal weekly rule. In states with daily overtime (for example California, after 8 hours in a day), your overtime may be higher than shown here.
Can I print or save my timesheet?
Yes — use the print button for paper, or download it as a CSV (numbers, or live formulas) in the section above and open it in Excel or Google Sheets.
Is my data saved?
No. Everything is calculated in your browser; nothing is uploaded or stored.
Related calculators
Overtime Calculator — start from total hours instead of clock times.
Work Hours Calculator — just one shift, start to finish.
Estimate for general information only — not tax, legal, or financial advice, and not a substitute for your employer's official time records. Overtime rules summarized from the U.S. Department of Labor (FLSA). See our methodology & sources.