Paid for Every Hour

Timesheet templates

Clean timesheets with no sign-up and no watermark. The Excel file does the adding up; the PDF prints blank to fill in by hand.

Weekly timesheet

One week, Monday to Sunday, with time in, time out, unpaid break and hours for each day.

Download for ExcelDownload PDF to print

Excel (.xlsx). Also opens in Google Sheets and Numbers.

Biweekly timesheet

Two weeks on one page for a two-week pay period. Overtime is worked out for each week on its own.

Download for ExcelDownload PDF to print

Excel (.xlsx). Also opens in Google Sheets and Numbers.

How do I fill out a timesheet?

Write the date, the time you started and the time you stopped for each day you worked, and how many minutes of break you were not paid for. Hours for the day are the time between start and stop, minus the unpaid break.

Add the days to get the week. Under US federal law, hours over 40 in a workweek are overtime, paid at one and a half times your rate, and each week is counted on its own even when you are paid every two weeks. Sign and date the sheet, and keep a copy.

What the Excel file works out

Type in the shaded cells: your time in, your time out and the minutes of unpaid break for each day. The file does the rest.

  • It works out the hours for each day, including a shift that runs past midnight.
  • It adds up the week and splits regular hours from overtime, which is the hours over 40 in a week.
  • On the biweekly sheet it counts each week's overtime on its own, as federal law requires.
  • If you enter your hourly rate, it works out your pay before taxes, with overtime at one and a half times.
  • If you enter the date the week starts, it fills in the dates and the names of the days.

The template uses the federal rule. If you work in California, where overtime is also counted by the day, use the time card calculator, which has that rule.

How to use it in Google Sheets

  1. Download the file for Excel.
  2. Open sheets.google.com and start a blank spreadsheet.
  3. Choose File, then Import, then Upload, and pick the file you downloaded.
  4. Choose “Replace spreadsheet” and import. The formulas keep working.

Type times like this: 7:00 AM, 3:30 PM.

How to fill it in by hand

Print the PDF and write your times down each day, not at the end of the week. To add up, turn minutes into decimals: 15 minutes is 0.25 hours, 30 minutes is 0.50 and 45 minutes is 0.75. A day from 7:00 to 3:30 with a 30-minute break is 8.00 hours.

If you would rather not do the sums, the time card calculator does them for you and prints a sheet as well.