Payroll tools 01

Time Card Calculator

Use this free time card calculator and timesheet calculator to enter shifts, subtract unpaid lunches, and export regular and overtime hours as a payroll CSV.

FORM TC-01

Time card

Saved on this device

Type 8:00 AM or 5:30 PM
Monday
Shifts
Unpaid breaks
—
Tuesday
Shifts
Unpaid breaks
—
Wednesday
Shifts
Unpaid breaks
—
Thursday
Shifts
Unpaid breaks
—
Friday
Shifts
Unpaid breaks
—
Saturday
Shifts
Unpaid breaks
—
Sunday
Shifts
Unpaid breaks
—

Add an unpaid break only if it falls inside a recorded shift. An out time earlier than an in time ends the next day.

Pay period totals

PAYROLL COPY
Regular REG
0:00
—
Overtime OT · 1.5×
0:00
—
Total hours
0:00
0.00 h
Gross pay
—
Before taxes

Running payroll? Get started with Gusto or QuickBooks Payroll.

THE WORKSHEET

How it works

  1. Set up the pay period

    Choose weekly, biweekly, semimonthly or monthly. Set the date shown on your first time card, then choose the day your employer’s workweek starts. The workweek and payday are separate. A Wednesday paycheck does not automatically mean your workweek starts on Wednesday. The weekly timesheet opens seven dates, and the biweekly timesheet opens fourteen. For semimonthly, pick a date in the first or second half of the month. Monthly uses the full calendar month.

  2. Enter clock punches and unpaid breaks

    Type each In and Out time from your time clock or paper sheet. Use + Shift for a second shift on the same date. Use + Break to record a separate unpaid meal during a shift. If you already punched out for lunch and entered the morning and afternoon as separate shifts, the gap is already excluded. Leave unscheduled days blank. You can switch between AM/PM and 24-hour time without changing complete punches.

  3. Review the hours, then export

    Choose the overtime rule that applies to the person on the card. Enter the applicable hourly rate if you want estimated gross pay; leave it blank to export hours alone. Check the daily net hours against your original punches, then review the period’s regular, overtime and, when applicable, double-time totals. Add an employee name if payroll needs it to match the file. Download a fresh CSV after making corrections.

THE PAY RULES

Overtime rules

Calculate overtime using the employer’s fixed workweek, even when a paycheck covers more than one week. For example, 45 hours in one week and 35 in the next are 40 regular plus 5 overtime hours in the first week and 35 regular in the second. Averaging them to 40 would erase five hours of overtime. See the U.S. Department of Labor’s overtime guide for the federal rule for covered, nonexempt employees.

Daily over eight
Cap regular time at eight hours per day. A ten-hour day is eight regular hours plus two at 1.5×. This mode uses the daily threshold alone.
Weekly over forty
Count up to forty hours as regular in each workweek. A 44-hour week has four overtime hours, even when all four come from shifts shorter than eight hours.
Daily eight plus weekly forty
First mark the hours over eight each day. Then move any remaining regular hours over forty in the workweek into overtime. For six nine-hour days, six hours qualify daily and another eight qualify weekly: 40 regular and 14 overtime.
California standard
On a normal workday, time over eight through twelve is 1.5×; time over twelve is 2×. The tool also checks the weekly threshold and the seventh day when all seven days were worked in the same workweek. On that seventh day, the first eight hours are 1.5× and additional hours are 2×. A 13-hour ordinary day splits into eight regular, four overtime and one double-time hour. See the California Labor Commissioner’s overtime FAQ for exceptions and alternative schedules.

Already know how many hours qualify for overtime? Use the time and a half calculator to find your overtime rate and estimate the pay for those hours.

To compare both rates for the same hours, use the overtime calculator to see time-and-a-half and double-time pay side by side.

Gross pay multiplies each category by the entered rate and its multiplier, then rounds the estimate to cents. Bonuses, differentials, multiple rates, taxes and deductions can change payroll. If the card starts partway through a workweek, enter the preceding dates shown in the workweek context section so the calculator can carry in the hours already worked.

Use the salary to hourly calculator to compare annual salaries with hourly rates. For a rough paycheck estimate after the taxes you select, use the take home pay calculator.

Time card calculator with lunch

A 9:00 AM to 5:30 PM shift spans eight hours and thirty minutes. Add 12:00 PM to 12:30 PM as an unpaid break and the calculator returns eight paid hours. If the same shift has two unpaid breaks, record them on separate rows so you can check both against the punches. A break must lie inside one recorded shift, and overlapping break intervals are flagged so the same minutes cannot be deducted twice.

Whether a break is paid depends on what happened and the rules that apply. Under federal guidance, short rest breaks generally count as work time. A bona fide meal period is generally unpaid only when the employee is relieved from duty. If an employee has to keep working or answer calls during lunch, check before deducting it. See the Department of Labor’s breaks and meal period guidance.

THE HANDOFF

Import into payroll

The download gives you a row for each date in the pay period, including the employee name if provided, the decimal hours by pay category, and the rate and estimated gross pay when entered. Check the employee spelling and dates before handing it off. For systems that need one row per employee per pay run, use the on-screen totals to fill the provider’s template. Do not add the total hours to the regular and overtime columns: the total already includes those categories.

Gusto: If available for your run, use Smart Import and confirm the employee and hours mapping in the preview. If matching fails, move the totals into Gusto’s current template or enter them by hand. QuickBooks: Follow Intuit’s payroll spreadsheet instructions if spreadsheet import is available on your plan; otherwise enter the hours in payroll. Always review the draft before running payroll.

Biweekly versus semimonthly: Biweekly repeats every 14 days and usually has 26 pay periods per year. Semimonthly has 24: this calculator uses the 1st through the 15th, then the 16th through the last date. A month’s second period can be shorter or longer than two weeks. Use the period that matches the payroll dates, then apply the workweek rule separately.

Time card vs timesheet

A time card records when someone started and stopped working. It can show a morning shift, a lunch punch, an afternoon shift and a return for an evening call. A timesheet summarizes the hours worked across a period. A supervisor might use the card to check a disputed clock-out and the timesheet to see the total hours to approve for payroll. Some workplaces call the same form by either name because it keeps both the punches and the totals.

If you start with clock punches and need totals for payroll, this free timesheet calculator handles both. Enter each In and Out pair as it appears on the card. The worksheet subtracts unpaid breaks that you record and groups the remaining time by date. Choose the overtime rule that applies so you can see regular hours, overtime and double time separately. If you add a rate, the calculator shows estimated gross pay for the same period. You can keep the original clock record and use the CSV as a separate payroll summary.

Use a weekly timesheet when you want to review a single workweek or when your employer pays every week. For example, five shifts from 8:00 AM to 4:30 PM with a 30-minute unpaid lunch add up to five eight-hour days. The time card shows ten shift punches and five lunches. The weekly timesheet shows 40 hours worked. If someone stays an extra 45 minutes on Friday, the card shows the later punch and the weekly total grows to 40 hours and 45 minutes.

A biweekly timesheet puts two weeks on one worksheet for a 14-day pay period. Set the pay period start to the first date on that record and set the workweek start to the day your employer uses. Suppose you have 43 hours in the first workweek and 37 in the second. Under the federal weekly overtime rule for covered, nonexempt workers, the first week still has three overtime hours. The two-week total of 80 does not change that split.

Before exporting, compare the displayed dates and daily totals with your source records. A missing Out time, a duplicate shift or a lunch entered twice can throw off the pay period even when the total looks plausible. If payroll asks for decimal hours, use the CSV values. For example, 7 hours and 45 minutes is 7.75 decimal hours. Keep the punch record if you need to explain how the total was calculated.

COMMON QUESTIONS

FAQ

How do I calculate hours on a time card?

Subtract In from Out for each shift, then subtract unpaid breaks. Add the net minutes across the dates. Divide minutes by sixty to get decimal hours: 7 hours 45 minutes is 7.75 hours.

Can I enter multiple shifts in one day?

Yes. Select + Shift for each separate block of work. The gap between shifts is already excluded, so you only need a break row for an unpaid break inside a shift.

How do I enter an overnight shift?

Use the date the shift began. An Out time earlier than In rolls to the next date, and the calculator splits worked minutes at midnight. If the new date is outside the pay period, the continuation is counted when you open the next period. Check shifts that cross a daylight saving clock change against your payroll records: the calculator uses the times on the clock without a time zone adjustment. Also verify the split if your employer uses a different workday cutoff.

Is lunch counted as hours worked?

Add an unpaid break only when the meal period can be excluded from work time. If the worker is still on duty, keep the time in the shift and check the applicable rules before making a deduction.

Does overtime reset every pay period?

Weekly overtime resets at the employer’s workweek boundary. When a pay period begins midweek, use the preceding dates shown above the period so the prior hours are considered without adding their pay to this file.

Is gross pay what I take home?

No. Gross pay is the estimated earnings before deductions, withholding or taxes. Compare the time categories and the hourly rate with your pay stub rather than using the calculator as a take-home pay estimate.

Will my time card still be here after I close the tab?

Normally, yes. This browser saves the card locally and opens it again on the same device. Private browsing, storage restrictions or clearing site data can remove the saved entries. Keep a dated CSV if you need a separate copy.

Will my payroll provider accept this CSV as-is?

It depends on the provider and your plan. Use the export to review the hours, map the fields in an available import tool or copy the totals into your provider’s template. The file does not submit payroll.