Excel Spreadsheet Timesheet Template: How to Make One

How-to basics · Updated November 22, 2026

The quickest way to get an Excel spreadsheet timesheet template is to open Excel and search the built-in template gallery (File > New, then type “timesheet” in the search box) or download a free one from Microsoft Create. But a pre-made template often doesn’t match how your company tracks hours, so this article shows you how to build a simple, accurate timesheet from scratch in Excel for Microsoft 365, with formulas that calculate daily and weekly totals automatically.

Why Use a Spreadsheet Instead of Paper or an App?

Paper timesheets get lost, are hard to audit, and require manual math. Dedicated time-tracking apps cost money and have a learning curve. An Excel timesheet sits in the middle: it’s free (if you already have Excel), fully customizable, and works offline. You can add columns for project codes, overtime rules, or paid time off. For a small business or a freelancer tracking a handful of clients, a well-built spreadsheet is often enough. It also gives you a permanent record you can sort, filter, and copy into an invoice or payroll report.

What a Basic Timesheet Template Should Include

A useful timesheet has at least these parts:

  • Employee or contractor name and the pay period dates (start and end).
  • Date for each workday (usually Monday–Friday, but you can add weekends).
  • Time in and time out columns, plus a separate column for unpaid breaks if you need net hours.
  • Daily total hours calculated by formula.
  • Weekly total at the bottom.
  • Overtime column (optional) if you need to separate hours over 40.
  • Notes column for project names or tasks.

For a simple weekly timesheet, put the days in rows and the time entries in columns. For a monthly view, you might prefer a grid with dates across the top and employees down the side, but that layout makes it harder to enter clock-in/out times. Stick with a vertical list of days for clarity.

How to Build a Timesheet in Excel (Step by Step)

These steps assume you’re using Excel for Microsoft 365 on Windows. On a Mac, the menus are the same names but located in the top menu bar; on Excel for the web, the formulas work identically, but the File > New gallery is slightly different.

  1. Set up the headers. In A1 type “Date,” B1 “Time In,” C1 “Time Out,” D1 “Break (minutes),” E1 “Daily Total (hours).” In G1 type “Weekly Total (hours).”
  2. Enter the dates. In A2 type the first workday (e.g., 6/3/2024). Then select A2, drag the fill handle (the small square at the bottom-right of the cell) down to A8 to fill the week. Excel auto-fills consecutive days. If you want only weekdays, use the fill handle with the right-click drag and choose “Fill Weekdays.”
  3. Format the time columns. Select B2:C8, press Ctrl+1 (Mac: Cmd+1), go to the Number tab, choose “Time,” and pick a format like 1:30 PM. For the break column, use a number format (e.g., 30 for minutes).
  4. Write the daily total formula. In E2, enter: =(C2-B2)*24-D2/60. This subtracts start from end, multiplies by 24 to convert the Excel time fraction into hours, then subtracts the break in minutes converted to hours. If you don’t track breaks, use = (C2-B2)*24. Copy the formula down to E8.
  5. Calculate the weekly total. In G2, enter: =SUM(E2:E8). This sums the daily totals. Format G2 as a number with two decimal places.
  6. Add overtime (optional). In F1 type “Overtime,” and in F2 enter: =IF(E2>8, E2-8, 0) if you track daily overtime, or use =IF(G2>40, G2-40, 0) in G3 for weekly overtime. Adjust the threshold to match your policy.

With the example above, if someone clocks in at 9:00 AM, out at 5:30 PM, and takes a 30-minute break, the daily total is (5:30 PM - 9:00 AM)*24 - 30/60 = 8.5 - 0.5 = 8.0 hours.

Common Problems and How to Fix Them

Several issues trip people up:

  • Negative hours if time out is before time in. This happens when a shift crosses midnight (e.g., 11:00 PM to 7:00 AM). Use this formula instead: =IF(C2. It adds 1 (a full day) when the end time is earlier than the start.
  • Wrong total because of formatting. If the weekly total shows 8:00 instead of 8.0, the cell is formatted as time. Select the cell, press Ctrl+1, and choose “Number” with 2 decimal places.
  • Breaks not subtracted. Make sure the break column is in minutes, not hours. If you enter 0.5 for a half-hour, the formula = (C2-B2)*24 - D2 would subtract 0.5 hours, not 30 minutes. Keep it consistent.
  • Employees entering times as text. Use Data Validation (Data > Data Validation) to restrict B and C columns to “Time” format, preventing typos like “9am” without a colon.

How to Choose the Right Template for Your Situation

Not every timesheet needs the same columns. Consider these scenarios:

  • Freelancer billing a client: Add a “Project” column and a “Rate” column, then a formula to multiply hours by rate. For example, with rate in H2, use =E2*H2 in I2.
  • Small business with hourly employees: Include overtime and a signature line. You can add a cell for employee name and a cell for manager approval.
  • Construction or field work: Add columns for location, weather delays, or equipment used.
  • Non-exempt employees under the Fair Labor Standards Act (FLSA): You must track all hours worked, including unpaid breaks of 20 minutes or less (if they are working) and meal breaks only if the employee is fully relieved of duty. Consult the Department of Labor or a qualified professional for specific rules.

If you need a template that already has these columns, search the built-in gallery for “timesheet” and filter by “Business” or “Employees.” Microsoft Create (create.microsoft.com) also has free downloadable templates that open directly in Excel.

Free vs. Paid Timesheet Templates

Free templates from Excel or Microsoft Create are usually enough for basic tracking. They often include conditional formatting to highlight weekends or totals over 40 hours. Paid templates (from third-party sites) might add automatic hourly rate calculations, drop-down lists for project codes, or multi-employee sheets, but you can replicate most of that with a few hours of work. The main advantage of a paid template is time saved, not features you can’t build yourself. Always check the file for macros before enabling them; a template with VBA code can be useful, but it can also contain errors or security risks. If you download a macro-enabled file (.xlsm), only enable macros if you trust the source.

Safety and Accuracy Tips for Timesheets

Accurate time records protect both the employee and the employer. Follow these practices:

  • Use 24-hour or AM/PM format consistently. A typo like 7:00 AM instead of 7:00 PM can shift hours by 12.
  • Lock the formula cells. Select E2:E8 and G2, press Ctrl+1, go to Protection, uncheck “Locked,” then protect the sheet (Review > Protect Sheet) so employees can only enter their times, not alter the math.
  • Keep a backup. Save a copy of the blank template before distributing, and store completed timesheets in a secure folder. Excel files can be password-protected (File > Info > Protect Workbook) to prevent unauthorized changes.
  • Double-check overtime rules. The formula =IF(G2>40, G2-40, 0) assumes a 40-hour workweek. Some states require overtime after 8 hours in a day, so adjust accordingly. This article is not legal advice; verify with your local labor department.

Frequently Asked Questions

Can I use Excel timesheet templates on Google Sheets?

Yes. You can download an Excel template and upload it to Google Sheets, or use Google Sheets’ own template gallery (Sheet > Template Gallery > Timesheet). The formulas are mostly the same, but Google Sheets uses ARRAYFORMULA for some operations, and the time format settings are in Format > Number > Custom date and time.

How do I calculate overtime in Excel timesheets?

For weekly overtime, use =IF(weekly_total_cell>40, weekly_total_cell-40, 0). For daily overtime, use =IF(day_total_cell>8, day_total_cell-8, 0). Place the formula in a separate column and adjust the threshold to your policy.

Why does my timesheet show 0.5 instead of 0:30 for a half-hour break?

Because you’re entering the break as a number (30) and dividing by 60 to get hours. If you want to enter the break as a time value (0:30), change the formula to = (C2-B2)*24 - D2*24 and format D as time. The method depends on how you choose to enter data.

Can I track multiple employees in one Excel timesheet?

Yes, but it’s easier to use one sheet per employee and a summary sheet that references the totals. For example, put each employee’s weekly total in a cell on their sheet, then on a summary sheet use =Sheet1!G2 to pull it. Alternatively, use a single sheet with a filter or pivot table, but that requires more setup.

Is it legal to use an Excel spreadsheet for timekeeping?

Yes, as long as it accurately records all hours worked and you keep the records for the required period (typically three years under federal law). The spreadsheet must be reliable and tamper-resistant. Protecting cells and using a consistent format helps, but you should also keep a backup copy.

How do I make a timesheet that automatically calculates pay?

Add a column for hourly rate, then multiply the daily total by the rate. For example, with rate in H2, use =E2*H2 in I2. For weekly pay, use =G2*H2 (or a more complex formula that separates regular and overtime rates). Remember to format the result as currency.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.