Free Timesheet Templates

Weekly timesheet with lunch break

One clock-in and clock-out per day, with unpaid break minutes subtracted. Totals regular hours, overtime after 40 and gross pay.

Best for: Most hourly jobs with one shift a day.

Day	Time In	Time Out	Break (min)	Hours
Monday	8:00 AM	4:30 PM	30	8.00

↓ Excel (.xlsx, 10 KB) ↓ Printable PDF

Weekly timesheet with lunch punches

Four punches a day: in, out to lunch, back from lunch, out. The gap between lunch punches is not counted. Leave the lunch punches blank on days without a lunch clock-out.

Best for: Workplaces where you clock out for lunch.

Day	In	Lunch Out	Lunch In	Out	Hours
Monday	8:00 AM	12:00 PM	12:30 PM	4:30 PM	8.00

↓ Excel (.xlsx, 10 KB) ↓ Printable PDF

Biweekly timesheet (2 weeks)

A 14-day pay period with a subtotal for each week. Overtime is worked out separately for week 1 and week 2, as federal law requires, then added up for the pay period.

Best for: Employers that pay every other week.

Week	Hours	Regular	Overtime	Pay
Week 1	45.00	40.00	5.00	$950.00

↓ Excel (.xlsx, 11 KB) ↓ Printable PDF

Monthly timesheet

One row for every day of the month; dates fill in from the month you enter. Groups days into workweeks (Sunday or Monday start) and works out overtime for each week.

Best for: Monthly records, contractors and semi-monthly payroll checks.

Date	Day	In	Out	Hours	Workweek
Nov 2	Monday	8:00 AM	5:30 PM	9.00	2

↓ Excel (.xlsx, 13 KB) ↓ Printable PDF

Prefer not to use a spreadsheet? The time card calculator and weekly timesheet calculator do the same maths in your browser and export to PDF or Excel.

How to use the templates

In Excel

Download the .xlsx file and open it in Excel.
Fill in the yellow cells: your name, the first day of the week, your hourly rate and the overtime rule.
Type each day's times, such as 8:00 AM or 16:30, and your unpaid break in minutes.
Daily hours, weekly totals, overtime and gross pay update automatically. The first row is an example; overwrite it.

In Google Sheets

Download the .xlsx file.
In Google Sheets, choose File → Import → Upload and select the file. Pick "Replace spreadsheet" or "Insert new sheet".
Fill in the yellow cells as above. All the formulas carry over.

The formulas inside

Each template uses plain formulas you can inspect and change:

What	Formula
Hours worked in a day	`=MOD(Out−In,1)*24 − Break/60`
Hours with lunch punches	`=(MOD(LunchOut−In,1)+MOD(Out−LunchIn,1))*24`
Regular hours	`=MIN(Total, 40)`
Overtime hours	`=MAX(0, Total − 40)`
Gross pay	`=Regular×Rate + Overtime×Rate×1.5`

MOD(…,1) is what makes overnight shifts work: a shift from 10:00 PM to 6:00 AM counts as 8 hours instead of a negative number. Hours are shown both as decimals (for payroll) and as h:mm.

Timesheet rules worth knowing

Overtime is per workweek. Under the Fair Labor Standards Act, non-exempt employees get at least 1.5× pay for hours over 40 in a workweek, and each week is counted on its own.
Short breaks are paid. Rest breaks of about 5 to 20 minutes count as hours worked. A meal break of 30 minutes or more can be unpaid if you are fully relieved of duty.
Keep the records. Employers must keep time cards for 2 years and payroll records for 3. Keeping your own copy is a good idea too.
Some states add daily overtime. California, for example, pays overtime after 8 hours in a day. Use the California overtime calculator for those rules.

Questions, answered

Things people actually ask.

Yes. Download the Excel and PDF files directly, with no sign-up and no email address needed.

Yes. In Google Sheets choose File, then Import, then Upload, and select the .xlsx file. The formulas for hours, breaks and overtime work the same way.

Each day uses =MOD(Time Out − Time In, 1) × 24 − Break minutes ÷ 60. MOD makes overnight shifts work: if you clock out after midnight, the time out is treated as the next day.

Hours over 40 in a workweek are paid at 1.5× the hourly rate, following the federal FLSA rule. You can change the threshold and multiplier. The templates do not apply state daily overtime; for California rules use the California overtime calculator.

Under federal law each workweek stands alone. Working 45 hours one week and 35 the next gives 5 hours of overtime, even though the two-week total is 80.

Yes. Each Excel template is set up to print on one page wide, and there are blank printable PDF versions for filling in by hand, with signature lines for the employee and supervisor.