Microsoft Excel Timesheet Template: Free Options

How-to basics · Updated November 20, 2026

Yes. Microsoft offers free timesheet templates for Excel through its template gallery, and you can also make a basic timesheet in a blank workbook. A template can track dates, start and finish times, breaks, and total hours, but you should check its formulas and adapt it to the way your workplace records time.

Where to find a free Excel timesheet template

In Excel for Microsoft 365 on Windows, open Excel and select File > New. Use the template search box to search for “timesheet” or “time sheet.” The results can include weekly and monthly trackers, employee time logs, and other schedules. Select a result to review it, then choose the option to create or download a copy. The precise selection of templates can change over time.

You can also browse Microsoft’s template gallery online and search for timesheets. A Microsoft account may be needed to access or save some online files. The templates themselves are generally available without a separate purchase, but using the desktop Excel application requires access to Excel through a license or subscription. Excel for the web is a no-cost option for people with a Microsoft account, although its available features and template experience can differ from desktop Excel.

Before entering real work records, save your own copy with a clear name, such as “Weekly Timesheet – Jordan Lee.” If you open a downloaded workbook, check that it is an Excel file from a source you trust. A template is a starting point, not a guarantee that its layout or calculations suit your organization.

What a timesheet template usually includes

A simple timesheet has one row per workday and columns for the date, start time, finish time, unpaid break, and hours worked. It may also include the employee’s name, team, supervisor, project, pay period, or a space for approval. A weekly layout is convenient when people submit time every week; a monthly or project-based layout may be more useful when tracking longer assignments.

Templates vary in what they calculate. Some just provide spaces to type times, while others calculate daily totals and sum the week. More elaborate workbooks may separate regular time, overtime, leave, or project hours. Check whether a total means elapsed hours, paid hours after breaks, or hours assigned to a particular task. Those are not necessarily the same number.

  • Basic time log: Records when work begins and ends.
  • Break-aware timesheet: Subtracts unpaid breaks from elapsed time.
  • Project timesheet: Separates hours by project, client, or activity.
  • Approval sheet: Adds review fields or sign-off space, which may be electronic or printed.

How to choose the right format

Start with how often the time is submitted and what information the person reviewing it needs. A weekly sheet is often easier to check for a regular schedule, while project work may need an entry for every task rather than just one total per day. If several people will use the same file, decide whether each person gets a separate workbook or whether a shared workbook will be maintained by an administrator.

Before settling on a template, look for the following:

  • Clear input cells: It should be obvious where users enter times and where formulas calculate totals.
  • Suitable pay period: The dates and number of rows should match the submission cycle.
  • Break handling: Confirm whether breaks are entered as hours, minutes, or start-and-finish times.
  • Useful totals: Check whether daily, weekly, and project totals are available if needed.
  • Readable print layout: If the sheet is printed, make sure names, dates, and totals fit on the page.

Do not choose a template just because it has more columns or a polished design. Extra fields can make entry slower and may collect information that is not needed. A short trial with a few ordinary workdays can reveal whether the structure works before it is distributed to a team.

How to enter and calculate hours

In Excel, enter start and finish times as actual times, such as 9:00 AM and 5:30 PM, rather than typing text such as “nine to five.” Set the cells to a time format if Excel does not recognize the entries. In a basic layout, use columns A through E for date, start, finish, unpaid break in hours, and daily hours. Enter 0.5 for a 30-minute break and 1 for a one-hour break.

With the start time in B2, finish time in C2, and unpaid break in decimal hours in D2, enter this formula in E2:

=MOD(C2-B2,1)*24-D2

For a shift from 9:00 AM to 5:30 PM with a 0.5-hour unpaid break, the formula returns 8 hours. Excel stores times as fractions of a day, so multiplying the difference by 24 converts it to hours. The MOD function also allows a shift that crosses midnight: for example, 10:00 PM to 6:00 AM with a 0.5-hour break returns 7.5 hours.

If the start or finish time might be left blank while someone is filling out a row, use a formula that leaves the result blank until both times are entered. With the same columns, put this in E2:

=IF(OR(B2="",C2=""),"",MOD(C2-B2,1)*24-D2)

Copy the formula down for the remaining days. With daily hours in E2:E8, put this total formula in E9:

=SUM(E2:E8)

If the seven daily results are 8, 7.5, 8, 8, 6, 0, and 0, the weekly total is 37.5 hours. The result is a simple sum; it does not decide which hours count as overtime or determine pay. Those rules depend on the employer’s process and applicable requirements, so confirm them with the appropriate workplace contact.

Formatting and adapting the workbook

Make input cells visually distinct from calculated cells, and label units explicitly. A break entered as 30 might be misread as 30 hours if the sheet expects decimal hours; a break entered as 0:30 is a time duration instead. Pick one method, explain it in the header or instructions, and test the totals. Similarly, decide whether a shift that starts before midnight and ends the next morning is entered on its start date or split across dates.

To change cell appearance in Microsoft 365 for Windows, select the cells and use options on the Home tab, such as the Number format menu. If you change column order, check every formula that refers to the old positions. You can use Formulas > Show Formulas to inspect formulas in the grid; select the command again to return to calculated results. In Excel for Mac, the ribbon has comparable formatting and formula controls, though some command locations and keyboard shortcuts differ. Excel for the web may also present a simplified ribbon.

Consider protecting formula cells from accidental edits while leaving entry cells available. Do not treat sheet protection as strong security: it is intended to prevent routine changes, not to keep sensitive information confidential. If multiple people edit a file, use a shared location with appropriate access settings and make clear who is responsible for checking the entries.

Common timesheet mistakes

A correct-looking sheet can still produce incorrect totals. The most common issues are inconsistent time entry, break units that do not match the formula, formulas that were not copied to every row, and a weekly total that omits the final day. Test the sheet with a known example and compare the result with a hand calculation before relying on it.

  • Times stored as text: A typed label may not calculate as a time. Re-enter it in a recognized time format.
  • Wrong break units: Subtracting 30 when the formula expects hours removes 30 hours, not 30 minutes.
  • Negative overnight result: A plain finish-minus-start formula can be negative for an overnight shift. A formula using MOD can handle that pattern, but confirm that the dates and policy are recorded correctly.
  • Unintended rounding: Rounding each day can produce a different total from rounding only the final sum. Use the rounding approach your organization specifies.
  • Overlapping entries: Two task rows covering the same time can inflate project totals if they are added together.

A formula cannot verify that the time entered is accurate or that a break was actually taken. Review entries against the relevant records and process, especially when a number will be used for payroll, billing, or project reporting.

Free templates, Excel, and alternatives

A downloadable Excel template is useful when you want to adjust columns, add project codes, or keep a workbook on a computer or shared drive. Excel for the web can be a practical no-cost way to edit a workbook online with a Microsoft account, while desktop Excel offers the fuller application experience for people who already have access to it. In either case, the underlying template does not replace a review of formulas or access permissions.

A spreadsheet may not be the best fit for every workplace. A shared workbook can become difficult to manage if many people edit different copies, if approvals need an audit trail, or if schedules and time entries need to connect to other systems. In those cases, an organization may prefer a dedicated time-tracking service or an existing payroll or project-management tool. Such services may charge fees, and their capabilities and data practices differ, so compare them against the organization’s actual needs.

Costs and safe handling

Microsoft’s template files are generally free to use, but access to the Excel desktop app may depend on a paid Microsoft 365 plan or another license. Excel for the web provides a browser-based alternative at no charge for eligible account holders. A third-party site may offer its own “free” template under different terms, so check for a stated price, sign-up requirement, or download condition before providing payment details or personal information.

Timesheets can contain names, schedules, client details, and other workplace information. Store them only in locations approved for that information, share with people who need access, and avoid putting confidential records in a publicly accessible link. Follow the employer’s retention and submission procedures rather than assuming a template sets those rules.

Frequently Asked Questions

Does Microsoft have a free timesheet template for Excel?
Yes. Search “timesheet” in Excel’s File > New template search or browse Microsoft’s online template gallery. Available designs can change, and some online actions may require signing in.

Can I use an Excel timesheet without paying for Excel?
Excel for the web is available at no charge to people with a Microsoft account. The desktop Excel application may require a license or subscription; the template file itself does not automatically grant a desktop-app license.

How do I calculate hours worked in Excel?
Subtract the start time from the finish time, convert the day fraction to hours, and subtract unpaid break time in matching units. For an overnight shift, a MOD-based formula can avoid a negative time difference. Test it against a shift you can calculate by hand.

How do I calculate overtime in a timesheet?
A weekly total alone does not define overtime. The threshold and calculation depend on the rules that apply to the workplace and the way its time is recorded. Confirm the correct method with the employer or payroll contact before adding an overtime formula.

Can I edit a free Excel timesheet template?
Yes. Save a copy, then change labels, dates, and input areas as needed. If you move columns or delete rows, inspect the formulas and test the daily and weekly totals again.

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.