Free download · Excel & Google Sheets

Free Employee Timesheet Template for Excel & Google Sheets

A clean, printable weekly timesheet template for tracking employee hours before you have a time clock. Enter clock in, breaks and clock out; daily hours, weekly totals and a pay period summary calculate for you. No sign-up, no email, no macros.

Updated · .xlsx, 124 KB · Works in Microsoft Excel (Windows, Mac, web) and Google Sheets

Google Sheets: download the .xlsx, then in Google Sheets choose File > Import > Upload (or upload it to Google Drive and open it with Google Sheets). The formulas work the same way.

Free employee timesheet template in Excel: the Timesheet tab filled in with a sample week, showing employee, date, clock in, meal break out and in, clock out, daily hours, week of, weekly total, hourly rate and estimated gross pay, including an overnight shift
The Timesheet tab with a sample week (sample names), including an overnight shift. The download is blank and ready to fill in.

What's in the employee timesheet workbook

TabWhat it does
How to useA short guide to filling in the sheet.
SetupCompany name, workweek start day, pay period (weekly, biweekly or semimonthly) and an employee list with optional ID, hourly rate and department.
TimesheetOne row per shift: employee (drop-down), date, clock in, meal/break out and in, an optional second break, clock out, notes and supervisor initials. Daily hours, week totals and an estimated gross pay fill in automatically.
TimecardPick an employee and a week for a one-page printable timecard with employee and supervisor signature lines.
SummaryHours by employee for each week and for the pay period, with estimated gross pay (hours × rate).

Who this timesheet template is for

How to use the timesheet template

  1. Download the template. Download the free .xlsx and open it in Microsoft Excel, or import it into Google Sheets with File > Import > Upload.
  2. Fill in the Setup tab. Enter your company name, the day your workweek starts, your pay period (weekly, biweekly or semimonthly) and your employees, with an optional ID, hourly rate and department.
  3. Enter one row per shift. On the Timesheet tab, pick the employee from the drop-down, enter the date the shift started, then clock in, meal or break out and in, an optional second break, and clock out.
  4. Check the totals. Daily hours, the week the shift belongs to and each employee’s weekly total calculate in the grey columns. A cell that says "Check times" means a time could not be read.
  5. Print a weekly timecard. On the Timecard tab, choose an employee and any date in the week, then print the one-page card for the employee and supervisor to sign.
  6. Review the pay period. The Summary tab shows hours for every employee by week and for the whole pay period, with an estimated gross pay you can compare with payroll.

How hours, breaks and overnight shifts are calculated

Daily hours are clock out minus clock in, minus any meal or break you clocked out for (Meal/Break Out to Meal/Break In, and Break 2 Out to Break 2 In). A paid break you stay clocked in for is left blank, so it stays in the hours.

Overnight shifts: enter the date the shift started. When the clock-out time is earlier than the clock-in time, the sheet counts the time past midnight into the next day, and a break taken after midnight is handled the same way. A 10:00 PM to 6:30 AM shift with a 30-minute break comes out to 8.00 hours.

Weekly totals: each shift is assigned to a workweek using the start day you choose on the Setup tab, so the weekly total always matches your workweek, even when a shift crosses into the next day. The Summary tab adds the weeks into your weekly, biweekly or semimonthly pay period.

Estimated gross pay is hours × the hourly rate on the Setup tab, and nothing else. It is a simple planning estimate, not a payroll calculation, and the template does not apply any overtime or state rules.

Times: type 9:00 AM, 5:30 PM or 24-hour times like 17:30. Times typed as text are read too, and blank rows stay blank.

How to print a weekly timecard

Open the Timecard tab, pick the employee and type any date in the week. The card lists that employee's shifts for the week with daily hours, the week total and estimated gross pay, followed by a confirmation line and employee and supervisor signature lines. Every tab is set to print landscape and one page wide; to print only the Timesheet rows you filled in, select them and choose Print Selection.

When to move from a spreadsheet to a time clock

A small business time tracking spreadsheet works well while the team is small and one person enters the hours. It is usually time to move to a time clock app when you have more than about 15 to 20 hourly employees, more than one location, frequent missed punches or edits, or you want punches recorded automatically and exported to payroll. Until then, this template keeps hours organized in one place.

Built to be easy

Frequently asked questions

Is the timesheet template really free?

Yes. Download it, copy it and share it. There is no sign-up and no email required.

Does it work in Google Sheets?

Yes. The formulas use only functions that work the same way in Microsoft Excel and Google Sheets, and there are no macros. Upload the .xlsx to Google Drive and open it with Google Sheets, or use File > Import.

How does it handle overnight shifts?

Enter the date the shift started. When the clock-out time is earlier than the clock-in time, the sheet counts it into the next day, for shifts up to 24 hours.

Can I type 24-hour times?

Yes. 9:00 AM, 5:30 PM and 17:30 all work. Times typed as text are read too.

How is gross pay estimated?

Hours × the hourly rate from the Setup tab, and nothing else. It is a simple estimate for planning, not a payroll calculation.

Can I change the formulas?

Yes. Formula cells are locked so they are not overwritten by accident, but there is no password. Unprotect the sheet to edit them.

How are meal and break times counted?

A meal or break you clock out for (Meal/Break Out and In, and Break 2 Out and In) is subtracted from the shift. A paid break you stay clocked in for is simply left blank, so it stays in the hours.

When should I switch from a spreadsheet to a time clock?

A spreadsheet works well for a small team. Consider a time clock app once you have more than about 15 to 20 hourly employees, several locations, frequent missed punches or edits, or you want punches recorded automatically and sent to payroll.

More free tools

When a week is filled in, you can upload the workbook for a free pre-payroll review. PunchAudit reads the Timesheet tab automatically.