HoursTools
  1. Home
  2. Time Card Calculator

Form No. 02 · Weekly time card

Time Card Calculator

Fill in a week of in and out times with lunch breaks. You get daily hours, the week’s regular and overtime hours, and gross pay at your rate. The card is saved in your browser and prints on one page.

HoursTools · No. 02Weekly time card
$
Lunch entry
Mon

Tue

Wed

Thu

Fri

Sat

Sun

Week totals
Total hours0:00
Regular0.00
Overtime0.00
Gross pay–

How to fill in the time card

Work down the card one day at a time. Enter the time you clocked In, the time you clocked Out, and the unpaid lunch in minutes. Days off stay blank. Hours for each day appear at the end of the line, and the totals box adds up the week.

If your time clock records four punches a day — in, out to lunch, back from lunch, out — choose 4 punches under Lunch entry. Each day then takes the four times exactly as printed on the card, and the lunch length is worked out from the two middle punches.

  1. Add your hourly rate to see gross pay. Leave it blank if you only need hours.
  2. Pick the overtime rule. Most US workers are under the federal rule: time and a half for hours over 40 in the workweek. The daily option also pays overtime past 8 hours in a day, which is how Alaska works; for California’s double time or Colorado’s 12-hour rule use the overtime calculator.
  3. Set Week starting if you want dates on the card. The first line becomes that date and the rest follow in order, so set it to the first day of your employer’s workweek.
  4. Use Print time card for a paper copy to sign, or Download CSV to open the week in Excel or Google Sheets.

The card is saved in this browser as you type. Clear it when you start a new week.

The math behind a weekly time card

Each day is worked out in minutes, the week is added up, and only then is overtime split off. Under the federal rule there is no daily overtime; a 12-hour Monday is not overtime by itself, but it counts toward the 40.

Daily hours = (Out − In) − unpaid lunch Week total = sum of the 7 days Regular hours = the first 40 hours of the week Overtime = week total − 40 (if positive) Gross pay = regular × rate + overtime × rate × 1.5

With the daily option on, hours past 8 in a day are counted as overtime first, and the weekly 40 is then applied only to the remaining regular hours, so no hour is paid as overtime twice.

Worked example: one week at $22.00 an hour

DayInOutLunchHours
Mon7:00 AM3:30 PM308:00
Tue7:00 AM5:00 PM309:30
Wed7:00 AM3:30 PM308:00
Thu7:00 AM4:45 PM459:00
Fri7:00 AM4:30 PM309:00
Week43:30

43 hours 30 minutes is 43.5 hours. The first 40 are regular: 40 × $22.00 = $880.00. The other 3.5 are overtime at $33.00 (1.5 × $22.00): 3.5 × $33.00 = $115.50. Gross pay for the week is $995.50.

Notice that no single day reached overtime under the federal rule — it is the weekly total that crosses 40. With the daily option, Tuesday’s 1.5 hours and Thursday’s and Friday’s hour each past 8 would be overtime instead (3.5 hours), and the weekly total stays at 40 regular, so in this week both rules happen to give the same pay.

What a time card has to show

Federal recordkeeping rules don’t prescribe a form, but they do require employers of non-exempt staff to keep the hours worked each workday and the total hours each workweek, along with the regular rate, straight-time earnings and overtime pay for the week. Time cards themselves must be kept for at least two years; payroll records for three.

A few habits keep a time card defensible:

  • Record actual times, not a schedule. A card that shows 8:00 to 5:00 every day for months looks copied, and it often is.
  • Write down the lunch that was really taken. If lunch was interrupted by work, it may not be a valid unpaid meal period.
  • Keep the workweek fixed. The FLSA workweek is any fixed run of seven consecutive days; it doesn’t have to be Monday to Sunday, but it can’t move around to dodge overtime.
  • Have the employee check and sign it. Disputes are much easier to settle with a signed card.

When gross pay here won’t match the paycheck

The pay figure is hours times rate, before tax. Your actual check will be lower after federal and state withholding, Social Security and Medicare, and any benefit deductions. It can also be higher on the overtime side: if you earn a shift differential, a production bonus or commissions, federal law folds those into the regular rate used for overtime, so each overtime hour is worth more than 1.5 × your base wage. The shift differential calculator shows how that blended rate is worked out.

If you are paid every two weeks, overtime is still figured week by week. Use the biweekly timesheet calculator so the two weeks are kept separate.

Questions people ask

How do I calculate my time card with a lunch break?

For each day, subtract the in time from the out time, then subtract the unpaid lunch. 7:30 AM to 4:00 PM is 8 hours 30 minutes; with a 30-minute lunch that leaves 8 hours. Add the days together for the week.

Is overtime calculated per day or per week?

Under federal law, per week: hours over 40 in the workweek. A few states also have daily overtime — California, Alaska, Nevada (for lower-paid workers) and Colorado (over 12 hours). The overtime calculator applies those state rules.

Can I open the time card in Excel?

Yes. Download CSV saves a file with each day’s in, out, lunch and hours plus the week totals. Excel, Numbers and Google Sheets all open it directly.

How long must an employer keep time cards?

Under the federal recordkeeping rules, time cards must be kept for at least two years and payroll records for at least three. Some states require longer.

Does this work for night shifts?

Yes. If the out time is earlier than the in time, the shift is counted as running past midnight. Enter it on the day the shift started.

Sources