I built this time card maker because every “free” time card I found online let me down in the same three ways: it was a locked PDF I couldn’t actually edit, a spreadsheet that broke the moment I changed one cell, or a template hiding behind a sign-up wall. I just wanted one page where I could set a card up the way a real workplace needs it — pick the pay period, add a lunch break, switch on overtime — and walk away with a file I own. So that is what this is: you answer a few quick questions at the top of the page, watch the card build itself, and download it as an Excel spreadsheet, a PDF, or a Word document. Nothing to install, no account, and your hours never leave your browser.
Time card vs. timesheet — which one do you actually want?
People use these two words interchangeably, but they are not quite the same thing. A time card is the compact, per-employee record of clock-in and clock-out times for a single pay period, usually printed and often signed. It comes from the old punch-card era, which is why it is small, why it lives on paper so often, and why people still print several to a page. A timesheet tends to be broader: more like a log where hours get grouped by project or task, frequently used by salaried staff, freelancers, and agencies.
If you are handing a physical card to hourly staff to fill in, or you run their clock-in times through payroll, a time card is what you want, and you are in the right place. If you would rather log hours by project across a longer stretch, my timesheet template is set up for exactly that. They share the same engine, so you can try both and keep whichever fits.
How to make a time card in Excel
The single most common request I get is a time card in Excel, and it makes sense — a spreadsheet does the math for you, so nobody is adding up columns of minutes by hand at the end of the week. The catch is that the free Excel time cards floating around tend to be fragile: delete a row, insert a column, or change the lunch rule and the formulas fall apart.
The version this page builds is different in one important way: the Excel file it hands you keeps its formulas live. The daily totals, the regular-versus-overtime split, the weekly subtotals, and the pay column all recalculate the instant you change a punch, because the real spreadsheet math is written into the cells — not pasted in as frozen numbers. Turn on the hourly rate and it even carries your pay rate into a cell the pay column points at, so a raise is a one-cell edit.
If you would rather understand the formula yourself, or you are patching an existing sheet, here is the piece that trips most people up.
The Excel formula for hours worked
Say a clock-in time sits in cell C2 and the clock-out time sits in D2, both entered as real times (like 9:00 AM and 5:00 PM). The hours worked that day is:
=(D2-C2)*24
Multiplying by 24 turns Excel’s internal “fraction of a day” into ordinary hours. If a shift can run past midnight, wrap it so it never goes negative:
=MOD(D2-C2,1)*24
To subtract a lunch that is recorded as a number of minutes in E2:
=((D2-C2)*24)-(E2/60)
And if you punch out for lunch and back in — a morning pair in C2/D2 and an afternoon pair in F2/G2 — you just add the two spans, which is exactly how this tool handles a lunch break:
=(MOD(D2-C2,1)+MOD(G2-F2,1))*24
Format the result cell as a number (not as time) and you will see clean decimal hours like 7.5. That is the whole trick, and it is what runs under the hood when you download the Excel file here.
Prefer Google Sheets, Word, or a PDF?
Not everyone lives in Excel, so you get four ways out. The Excel download is the star because it carries live formulas. There is a copy-for-Google-Sheets button that puts the whole card on your clipboard so you can open a blank sheet and paste it straight in. The Word download gives you a clean, editable document if you would rather type into a page than a grid. And the PDF is the print-and-sign version — tidy, professional, and ready to email as-is.
Free printable time cards (and how to fit more on a page)
Sometimes you do not want a spreadsheet at all — you want a blank card you can print, clip to a board, and let people fill in by hand. That is the oldest use of a time card and it is still one of the best.
This is where the cards-per-page setting earns its keep. Leave your card blank, choose one, two, or four cards per printed page, and the PDF tiles that many copies onto each sheet with dashed cut lines so you know exactly where to trim. Four to a page turns a single sheet of paper into four blank weekly cards — handy for a small crew, a job site, or a shop where everyone still writes their hours down. Printable, foldable, and free.
Time cards with a lunch break
An honest time card has to deal with lunch, because most people are not paid for it. There are two clean ways to handle that, and this tool supports both. You can record the break as a number of minutes and let it subtract from the day. Or — the way I prefer — you can punch out and back in: a morning in-and-out and an afternoon in-and-out. When you use two pairs like that, the gap in the middle is simply left out of the total automatically, so the lunch takes care of itself. There is a three-shift option too, for split schedules where someone comes and goes more than twice.
Overtime, done by the book
If the card is going anywhere near payroll, overtime has to be right. Under the federal Fair Labor Standards Act (FLSA), most hourly employees earn overtime at one-and-a-half times their regular rate for time worked beyond 40 hours in a workweek. The U.S. Department of Labor sets that 40-hour line at the federal level, and a number of states layer a daily rule on top — California is the well-known example, where hours past 8 in a single day start counting as overtime.
You can switch the tool to match whichever rule applies to you: overtime after 40 hours a week, after 8 hours a day, both together, or none at all. It splits each period into regular and overtime hours for you, and if you have turned on the pay rate, it applies your overtime multiplier (1.5 by default) to the overtime portion only. When a pay period spans two weeks, the 40-hour test is applied to each week on its own, the way it is supposed to be — not to the two-week total.
An employee time card that looks the part
A card that is going into an employee file should carry the details that make it official, so you can switch on fields for the employee name, an employee ID, the department, and the manager or supervisor who approves it. Signature lines for the employee and approver are on by default, with a date line beside each, because a time card that nobody signs tends to be a time card nobody trusts. If you would rather keep it minimal, turn any of those off and the card tightens up around what is left.
Every pay period, one tool
Payroll runs on all sorts of schedules, so you can set the card to whatever yours is: weekly, bi-weekly, semi-monthly, monthly, or a single day. Enter the pay period start date and the tool fills in the dates and weekdays for you, so a monthly card is not thirty rows of manual typing. Bi-weekly and monthly cards are fully supported, overtime and all.
Built for real workplaces
Because the fields are yours to switch on and off, the same page covers a lot of ground. Construction crews and job-site foremen tend to want a simple printable card with a project or job column, a few of them to a page. Small businesses and restaurants usually want the lunch-break split and a running pay total. Payroll admins want the live-formula Excel file and clean weekly subtotals. It is one tool, shaped to fit, rather than a different download for every situation.
If you are organizing more than just hours, it may pair well with a few of my other free tools — an hourly planner for mapping out the day itself, or the rest of my business templates for the paperwork around it.
How to calculate hours worked on a time card
If you are adding it up by hand: convert each clock-out and clock-in to a 24-hour time, subtract the in from the out to get the span, then subtract any unpaid break. Add the days together for the period total. The fiddly part is minutes — 8:45 is not 8.45 hours, it is 8.75 — which is exactly the kind of mistake a spreadsheet exists to prevent. Many workplaces also round each entry to the nearest quarter hour for payroll, and you can set that rounding here so the totals come out consistent with your own rules. Let the tool do it, download the file, and move on with your day.
Time card template FAQ
Is this time card maker really free?
Yes — completely free, with no account and no watermark. Build your card, download it as many times as you like in whatever format you need, and that is it.
Can I get my time card in Excel?
Yes, and the Excel file is the one I would reach for. It downloads with live formulas, so the daily hours, the regular-versus-overtime split, the weekly subtotals, and the pay column all recalculate the moment you change a punch. You are not getting a picture of a spreadsheet — you are getting a working one.
Does it work with Google Sheets?
It does. Use the copy-for-Google-Sheets button, open a blank sheet, and paste. Your whole card lands in the grid, ready to edit.
How do I print more than one time card per page?
Set the cards-per-page option to two or four, leave the card blank, and download the PDF. It tiles that many copies onto each sheet with dashed cut lines, so you can print a stack of blank cards and trim them apart.
How do I add a lunch break?
Two ways. You can record the break as a number of minutes and it subtracts from the day, or you can punch out and back in for lunch — a morning pair and an afternoon pair — and the gap between them is left out of the total automatically.
How does overtime work?
You choose the rule. The default follows the federal FLSA standard of overtime after 40 hours in a week, but you can switch to a daily rule (after 8 hours a day), both together for California-style rules, or turn overtime off. The tool splits regular and overtime hours for you and applies your overtime multiplier to the overtime portion.
What is the difference between a time card and a timesheet?
A time card is the compact, per-employee record of clock-in and clock-out times for one pay period, usually printed and signed. A timesheet is generally broader and logs hours by project or task over a longer stretch. If you want the second kind, use my timesheet template instead.
Can I use it for construction or a small business?
Absolutely. Turn on a project or job column, choose a simple layout, and print a few cards to a page for the crew — or keep the lunch split and pay total for a shop or restaurant. The fields are yours to switch on and off.
My name is