Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| Mon | Tue | Wed | Thu | Fri | Sat | Sun | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Employee | 46335 | 46336 | 46337 | 46338 | 46339 | 46340 | 46341 | Total hours | Regular hours | Overtime hours | Gross pay ($) |
| Daniel Brooks | 8.00 | 8.00 | 8.00 | 8.00 | 8.00 | 4.00 | 0.00 | 44.00 | 40.00 | 4.00 | 1,127.00 |
| Priya Shah | 8.00 | 8.00 | 8.00 | 8.00 | 8.00 | 0.00 | 0.00 | 40.00 | 40.00 | 0.00 | 690.00 |
| Marcus Webb | 9.50 | 9.50 | 8.00 | 8.00 | 8.00 | 0.00 | 0.00 | 43.00 | 40.00 | 3.00 | 801.00 |
| Chloe Evans | 7.50 | 0.00 | 7.50 | 0.00 | 0.00 | 0.00 | 0.00 | 15.00 | 15.00 | 0.00 | 251.25 |
| Tom Hadley | 8.25 | 8.25 | 8.25 | 8.25 | 8.25 | 0.00 | 0.00 | 41.25 | 40.00 | 1.25 | 837.50 |
| Grace Liu | 0.00 | 7.50 | 7.50 | 7.50 | 7.50 | 7.50 | 0.00 | 37.50 | 37.50 | 0.00 | 656.25 |
| Omar Haddad | 7.50 | 7.50 | 7.50 | 7.50 | 7.50 | 0.00 | 0.00 | 37.50 | 37.50 | 0.00 | 693.75 |
| Hannah Price | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 7.50 | 6.00 | 13.50 | 13.50 | 0.00 | 216.00 |
| Team total | 48.75 | 48.75 | 54.75 | 47.25 | 47.25 | 19.00 | 6.00 | 271.75 | 263.50 | 8.25 | 5,272.75 |
Example from the “Weekly” tab, with the numbers and formulas that are in the file.
What is inside
- Dashboard: The week's total, regular and overtime hours, gross pay, how many employees worked and how many are in overtime, the average hours, and the number of Time Log rows that need checking. Charts: hours by employee (regular and overtime), team hours by day, and team hours over the last six weeks.
- Weekly: One row per employee for the week set on Settings: hours for Monday to Sunday, total, regular and overtime hours, hourly rate, regular pay, overtime pay and gross pay, with a team total.
- Time Log: The shift log, with room for 2,000 shifts. Hours, the Monday of the week, the day name and a Check column are calculated. The check flags a missing time, a missing date or employee, an employee not on the list, or a shift over 16 hours.
- Time Card: Pick an employee and print: seven days with time in, time out, break and hours, then total, regular and overtime hours, rate, gross pay and signature lines for the employee and approver.
- Employees: ID, name, role and hourly rate for up to 40 people.
- Settings: Company, currency symbol, the Monday of the week to show, the hours after which overtime starts, the overtime multiplier and the approver's name.
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
Most weekly timesheet templates are a single card for one person. This one keeps one log for the whole team and builds the cards and the weekly pay summary from it, so you type each shift once. The sample is a small shop with eight employees over six weeks in October and November 2026.
How do I make a weekly timesheet in Excel?
Log each shift with a date, a time in and a time out, and subtract the break. The hours formula here is (time out - time in - break) x 24, wrapped so that a shift that ends after midnight still comes out right. A 22:00 to 06:00 shift with a 30-minute break is 7.5 hours.
Then add the hours for each employee by day. Keeping the log as one list, and summing it by employee and date, means you do not rebuild a sheet every week: change the Monday on Settings and the Weekly sheet and Dashboard show that week.
How is overtime calculated?
Overtime here is weekly: hours above the threshold on Settings (40 in the sample) in the Monday to Sunday week are paid at the hourly rate times the multiplier (1.5). In the week of 2026-11-09, Daniel Brooks works 44 hours, so 40 are regular and 4 are overtime. The team works 271.75 hours, of which 8.25 are overtime.
Overtime rules differ by country, state and contract, and some apply daily as well as weekly. Check your local rules; the threshold and multiplier are settings you can change, but daily overtime is not calculated.
Can I print a timesheet for each employee?
Yes. The Time Card sheet shows one employee's week from the log. Choose the name from the dropdown and print. If an employee worked two shifts on one day, the card shows Split for time in and out and adds the hours together. For a payroll view see the employee payroll and attendance sheet.
How to use it
- On Settings type the company name, currency symbol, the Monday of the week you want to see, the weekly hours after which overtime starts, and the overtime pay multiplier.
- On Employees list each person with an ID, name, role and hourly rate.
- On Time Log add one row per shift: the date, the employee (pick from the list), time in, time out and the unpaid break in minutes. Hours are worked out for you, including shifts that end after midnight.
- Open Weekly to see Monday to Sunday hours for every employee, regular and overtime hours, and gross pay for the week set on Settings.
- Open Time Card, pick an employee and print the page: it shows that person's shifts for the week with totals and signature lines.
- Open Dashboard for the week's totals, hours by employee and by day, and the last six weeks. To look at another week, change the Monday on Settings.
Before you start:
- Capacity: 40 employees and 2,000 shifts in the Time Log.
- Hours = (time out - time in - break) in hours. If time out is earlier than time in, the shift is treated as ending the next day. The shift belongs to the date it started.
- Overtime is weekly: hours above the threshold on Settings in one Monday-to-Sunday week are paid at the hourly rate times the multiplier. Daily overtime rules are not applied. Check your local rules before you pay anyone.
- A Check column on Time Log flags a row with a missing time, a missing or unknown employee, no date, or a shift over 16 hours. Flagged rows are counted on Dashboard.
- An employee can have more than one shift a day. The Time Card then shows "Split" for time in and out and adds the hours together.
- Gross pay is hours times rate only. Taxes, benefits and other deductions are not calculated.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
Is this timesheet template free?
Yes. Download it and change anything. Nothing to sign up for.
Does it handle night shifts?
Yes. If time out is earlier than time in, the shift is treated as ending the next day, and it belongs to the date it started.
How many employees and shifts?
40 employees and 2,000 shifts in the log. Start a new file when the log is full.
Does it calculate taxes?
No. Gross pay is hours times rate only. Taxes, benefits and deductions depend on where you are and are not included.
How do I see a different week?
Type the Monday of that week on Settings. A warning appears if the date is not a Monday.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
More free templates for: Human resources
More free templates
- Employee Leave Tracker Template for Excel
- Inventory Tracking Spreadsheet for Excel
- Expense Tracker Template for Excel
- Monthly Household Budget Template for Excel
- Cash Flow Forecast Template for Excel (12 Months)
- Fixed Asset Depreciation Schedule for Excel
- Customer Statement Template with Aging (Excel)
- Gym Membership Tracker for Excel
- Freelance Project and Invoice Tracker for Excel