Skip to content

Time Card Calculator

A week of 8:00 AM to 4:30 PM with a 30-minute lunch is a 40-hour time card — $720 at $18 an hour. Fill in one or two weeks, then print the card or download it as CSV.

Week 140:00 h

Mon, Oct 26
Mon, Oct 268:00 h
Tue, Oct 27
Tue, Oct 278:00 h
Wed, Oct 28
Wed, Oct 288:00 h
Thu, Oct 29
Thu, Oct 298:00 h
Fri, Oct 30
Fri, Oct 308:00 h
Sat, Oct 31
Sat, Oct 31Off
Sun, Nov 1
Sun, Nov 1Off
Pay period
Overtime rule
Round In / Out to
Names and notes for the printed card

Names and notes appear on the printout only; they are not put in the share link.

Hours Oct 26, 2026 – Nov 1, 2026

40:00 h

Decimal hours
40
Regular hours
40
Overtime hours (1.5×)
0

Overtime is worked out for each workweek on its own — hours over 40 in that week.

How it’s calculated
  1. Week 140 reg + 0 OT = 40 h

Updates as you typeNo sign-upShare the link and your numbers travel with it

How to fill out a time card

  1. Pick the pay period: the first day (it starts on this week’s Monday) and 1 week or 2 weeks. Each row is dated for you.
  2. Enter In and Out times for each day you worked; leave days off empty. Use Copy Mon to the next 4 days when every weekday is the same.
  3. Enter unpaid breaks in minutes, such as a 30-minute lunch. Short paid rest breaks stay in the hours.
  4. Choose the overtime rule — federal, or California’s daily rules — and add your hourly rate for the pay.
  5. Print, download or share: Print gives a time card with names, a table of every day and signature lines; CSV downloads it for Excel or payroll; Share copies a link that brings the whole card back. Names you type stay out of the link.

For a single shift, the hours calculator is quicker; for the hours of one week without dates, the work hours calculator.

Biweekly time cards and overtime

Overtime belongs to the workweek, not to the pay period. Federal rules define a workweek as a fixed, recurring period of seven consecutive 24-hour periods (29 CFR 778.105), and each one is checked against 40 hours on its own:

Two-week card at $20/hour Hours Overtime Gross pay
Week 1: Mon–Fri 9:00 AM–6:30 PM, 30-min lunch 45 5 $800 + $150 = $950
Week 2: Mon–Thu 9:00 AM–5:30 PM, 30-min lunch 32 0 $640
Pay period 77 5 $1,590

Averaging the two weeks (38.5 hours each) would wrongly show no overtime. The card gives each week’s regular and overtime hours separately, under How it’s calculated.

California time cards

With the California rule, each day is checked as well: hours over 8 in a day are overtime, hours over 12 are double time, and a seventh straight workday has its own rule (Labor Code 510). Three 12-hour nursing shifts at $45 — 36 hours in the week — are 24 regular hours and 12 overtime hours, $1,890, where the federal rule would give $1,620. The overtime calculator explains each California rule with examples.

Rounding and breaks

  • Rounding: time clocks often round each punch to the nearest 5 minutes, tenth of an hour (6 minutes) or quarter hour. Federal rules allow it when it averages out so employees are paid for all the time they work (29 CFR 785.48). Choose the same rounding as your employer’s clock to match their card.
  • Breaks: rest breaks of about 5 to 20 minutes are paid work time; meal breaks of usually 30 minutes or more, completely off duty, are not. Enter only unpaid breaks.
  • Night shifts: a shift that ends after midnight is counted on the day it started and marked next day.

Printing and exporting your time card

Action What you get
Print Period dates, employee and employer names, a row per day (In, Out, break, hours), week totals with overtime, gross pay and signature lines for the employee and supervisor
CSV One row per day worked — date, week, decimal hours, h:mm, night shift — plus week and period totals and gross pay
Share A link that restores the dates, times, rule, rate and rounding (not names or notes)
Copy A plain-text summary with each week’s totals

Time cards in Excel

Open the CSV in Excel or Google Sheets, or build a sheet with In in column B, Out in C and break minutes in D:

  • Hours per day: =MOD(C2-B2,1)*24-D2/60
  • Week total: =SUM(E2:E8); overtime: =MAX(0,E9-40)
  • Gross pay: =MIN(E9,40)*rate + MAX(0,E9-40)*rate*1.5

Format time totals as [h]:mm so that weeks over 24 hours are not cut short. The pay shown here and in the CSV is gross, before taxes and deductions; it uses one hourly rate, so bonuses and shift differentials that change the regular rate are not included.

Frequently asked questions

How do I calculate a time card?

For each day, take the clock-out time minus the clock-in time and subtract unpaid breaks; add the days for the week. Overtime is every hour over 40 in that week, paid at 1.5 times the regular rate. The calculator does each step and shows the hours per day, per week and for the whole card.

How do I fill out a biweekly time card?

Choose 2 weeks and enter the first day of the pay period. Fill in both weeks; each is totaled on its own. 45 hours in week 1 and 32 in week 2 is 77 hours with 5 hours of overtime — from week 1 only.

Is overtime figured per week or per pay period?

Per workweek. Federal rules treat each workweek separately, so hours are not averaged across a two-week pay period (29 CFR 778.105). A biweekly card of 45 and 32 hours still has 5 overtime hours.

Can I download my time card to Excel?

Yes. The CSV button downloads one row per day worked with the date and hours (decimal and h:mm), plus week and period totals. Excel, Google Sheets and most payroll systems open CSV files.

How do I write a night shift on a time card?

Enter the real clock-in and clock-out times — 10:00 PM in, 6:30 AM out. The card counts it on the day the shift started and marks it as ending the next day: 8 hours 30 minutes, or 8 hours after a 30-minute break.

How do I convert time card hours to decimal?

Divide the minutes by 60: 7 hours 45 minutes is 7.75 hours. The card shows both, and the CSV has decimal hours ready for payroll.

Related calculators