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

If you are asking how to make a timesheet in Excel, start with the payroll question instead of the design question. The workbook must answer who worked, when they worked, how much unpaid break time should be deducted, which hours count as regular time, which hours need overtime review, and who approved the record. Colors and borders can wait.

For the full two-week payroll tracking hub, see Biweekly Employee Timesheet Template Excel.

Step 1: Define the Pay Period

Create a header section with employee name, employee ID, department, supervisor, pay period start date, and pay period end date. For a biweekly sheet, the date range should cover 14 calendar days. Do not rely on a filename alone; payroll reviewers need the dates inside the workbook.

Set up the date rows

1. Enter the pay period start date in a header cell.
2. Create 14 date rows beneath it.
3. Use a formula to add one day per row.
4. Add a weekday column so weekends are visible.
5. Keep blank rows out of the data range.

A clean date section prevents one common error: copying last period's file and forgetting to update all row labels.

Step 2: Add Time Entry Columns

Use separate columns for Time In, Time Out, Break, Total Hours, Regular Hours, Overtime Hours, and Notes. If employees work split shifts, either add second in/out columns or create a second row for the same date. The second-row method is often easier to audit because each shift remains visible.

Timesheet columns to create in Excel

Step 3: Calculate Hours Worked

Excel can calculate time, but formatting matters. If Time Out is later than Time In on the same day, the basic idea is: end time minus start time, multiplied by 24, minus break hours. For overnight shifts, you need an additional rule because the end time may appear earlier than the start time.

Keep the formula visible in a protected column. Employees should enter times and breaks, not overwrite total-hour math. If you plan to export to payroll, decimal hours are usually easier than clock-style durations.

Step 4: Separate Regular and Overtime

A simple template can cap regular hours and send the rest to an overtime column. The exact overtime rule depends on location, classification, and company policy, so treat the formula as an operational aid rather than legal advice. Many teams still want weekly subtotals inside a biweekly sheet because overtime review may depend on week-level thresholds.

For more detail, read Overtime Timesheet Template Excel: Hours Worked vs OT.

Step 5: Add Approval Fields

A timesheet without approval fields is just a draft. Add employee signature/date and supervisor approval/date. If signatures happen outside Excel, add a submitted-by and approved-by text field and keep the signed record in the same payroll folder.

Step 6: Protect the Right Cells

Protect formula columns, header labels, and totals. Leave input cells unlocked. Use light fill colors to show where employees type. Add a short instruction note above the grid so the file does not need a separate training document.

Step 7: Create a Payroll Review Area

At the bottom or top of the sheet, summarize regular hours, overtime hours, PTO hours, unpaid time, and total payable hours. Payroll should not need to scan 14 rows to find the answer, but the detail should remain available for review.

When to Use a Ready Template

If you only need one employee and enjoy formulas, a blank workbook is fine. If you manage recurring payroll, a structured file saves setup time and reduces missed fields. The Biweekly Employee Timesheet Template Excel is available as a one-time purchase; check the product page for current details rather than relying on a fixed price in an article.

For multiple employees, see Multiple Employee Biweekly Timesheet Template Excel. For broader field selection, see Employee Timesheet Template Excel: Fields That Survive Payroll.

QA Checklist Before You Share the File

• Dates cover the full pay period.
• Time cells accept real time values.
• Breaks reduce total hours.
• Formula cells are protected.
• Regular and overtime hours are visible separately.
• Approval fields are present.
• The workbook is saved as a clean master copy before employees use it.

The best Excel timesheet is not the fanciest one. It is the one employees can complete quickly and payroll can trust without chasing missing context.

Practical Testing Before Rollout

After the first draft of the workbook is built, test it like a payroll reviewer instead of like the person who wrote the formulas. Enter one perfect day, one day with an unpaid lunch, one day with a missing clock-out, one short day, and one long day that should trigger overtime review. The goal is to see whether the workbook explains itself when entries are imperfect. If a blank time-out creates a strange negative number, add a warning or leave the calculated cell blank until both source times are present.

Also test how employees will actually type. Some people enter 8am; others enter 8:00 AM; others paste from a phone note. Excel can handle many formats, but the workbook should make the expected format obvious. A small instruction line above the entry area can prevent dozens of corrections later.

Archiving the Master File

Keep one clean master copy that nobody uses for live payroll. At the start of each pay period, duplicate it and rename the working file with the employee name or ID and the pay period end date. That one habit protects formulas from slow drift. Without a master, every corrected file becomes the new unofficial template, and small changes spread until no two timesheets calculate exactly the same way.

Final Payroll Readiness Pass

Before a timesheet article, template, or workflow is considered finished, run one final payroll readiness pass. Read the sheet from the viewpoint of someone who did not build it and does not know the backstory. Can that person identify the pay period, the employee, the source time entries, the break deductions, the regular hours, the overtime hours, and the approval status in less than a minute? If not, the workbook still has friction.

This pass should also catch language problems. Labels such as total, adjustment, and other may be clear to the creator but vague to payroll. Replace them with operational labels: total hours worked, unpaid break, approved correction, regular hours, overtime hours, or PTO. Clear labels reduce training time and make archived records easier to understand months later.

Finally, test the workflow around the file. Decide who creates the pay-period copy, who enters time, who reviews exceptions, who approves the final record, and who archives it. Excel can hold the numbers, but the process around the workbook determines whether those numbers arrive on time. A simple, repeated routine is better than a clever file that no one knows how to close.

Keep the template stable after rollout. If every pay period brings a new layout, employees lose trust and payroll has to relearn the record. Collect improvement notes during the period, then update the master copy between cycles. That gives the team a predictable timesheet today and a better one next pay period.

Frequently Asked Questions

What is the formula for hours worked in Excel?

A common pattern is end time minus start time, multiplied by 24, then minus unpaid break hours. Test the formula with your time format.

Should employees type total hours manually?

Usually no. Let employees enter clock times and breaks, then protect calculated total columns.

Can Excel calculate overtime?

Excel can separate hours into regular and overtime columns, but the rule should be reviewed against your payroll policy and applicable requirements.

Disclosure

PlanoNest sells digital Excel, Google Sheets, and Notion templates. When this article links to PlanoNest products or collections, those links point to our own template shop.