PastelyArchlyv2.3
Timecard
Get TimecardGet $5
Free toolNo sign-up · Runs in your browser

Timesheet template

Pick weekly, every two weeks or monthly, add the employee, employer and hourly rate, and download the timesheet. The Excel file has formulas that add up each day, overtime past 40 hours a week and gross pay as you fill it in. There's a CSV for Google Sheets and Numbers, and a version to print or save as PDF.

How to fill in a timesheet

  1. Write the time you started and stopped each day, in 24-hour time or with AM and PM.
  2. Put unpaid breaks in minutes. Paid breaks stay in the day.
  3. Leave days off blank. The day counts as zero.
  4. Check the weekly total, sign it, and send it to whoever runs payroll.

Which template to use

Pay periodPaychecks a yearBest for
Weekly52Hourly and shift work
Every two weeks26Most US employers
Monthly12Freelancers and contractors who invoice monthly

How the formulas work

Daily hours are clock out minus clock in, times 24, minus the break in hours, so 9:00 to 17:30 with 30 minutes off is 8.00. In the Excel file, a shift that ends after midnight wraps around. Each 7-day block adds up, hours past 40 are overtime at 1.5×, and gross pay is regular hours × rate plus overtime hours × rate × 1.5.

Prefer not to fill in anything? The time card calculator does the maths on the page, and Timecard records your hours on a Mac by itself.

Timesheet Template
questions

Is this timesheet template free?

Yes. Download it as many times as you like, for Excel, Google Sheets, Numbers or print. There's no sign-up and nothing you type is sent anywhere.

Does the Excel timesheet calculate hours automatically?

Yes. Each day's hours are clock out minus clock in, minus the break, and shifts past midnight work too. Each week adds up, anything over 40 hours counts as overtime at time and a half, and gross pay uses your hourly rate.

How do I use it in Google Sheets?

Download the CSV, then in Google Sheets choose File › Import › Upload and pick the file. The daily hours, weekly totals and pay are formulas, so they update as you type times like 9:00 and 17:30. Or upload the Excel file to Google Drive and open it with Sheets.

Which pay period should I pick?

Match your payroll. Weekly suits hourly jobs paid every week, every two weeks is the most common US pay schedule, and monthly suits freelancers who invoice once a month. Overtime is counted per 7-day week in every version.

Can I track hours without filling in a timesheet?

On a Mac, Timecard records when you start and stop using your computer and prints each day as a timecard, so the hours are there when you need them.

More free tools

Time Card Calculator

Add up a week of hours, breaks, overtime and pay.

Open →

Hours Between Two Times

Find the hours and minutes between any two times, even past midnight.

Open →

Work Hours in a Year

How many working hours and days are in a year, after holidays and time off.

Open →

Decimal Hours Calculator

Convert hours and minutes to decimal hours, and back.

Open →

Meeting Cost Calculator

What a meeting costs in salary, once or every week, with a live meter.

Open →

Hourly to Salary Calculator

Convert hourly pay to a yearly salary and back, with overtime.

Open →

Screen Time Calculator

How many years of your life will you spend on screens?

Open →

Military Time Converter

Convert 24-hour military time to standard time, with a full chart.

Open →

AI Token Counter

Count tokens for GPT, Claude and other models, and see what a prompt costs.

Open →