Reviewed & updated by WordNExcel Team — Updated November 10, 2026
An employee timesheet template is the simplest way to record the hours your staff work and turn them into an accurate pay figure. Instead of adding up start and finish times on paper, you type the clock-in and clock-out times, and the sheet subtracts unpaid breaks, totals the week, separates overtime and calculates gross pay. On this page you can download five free employee timesheet templates in Excel: a weekly timesheet with lunch breaks and overtime pay, a biweekly timesheet for two-week pay periods with sick and vacation hours, and a monthly team hours tracker for managers who need to see everyone’s hours on one sheet, plus a project and job-cost timesheet and a clock-in and clock-out timesheet with daily overtime.
All five files are real, editable .xlsx workbooks that we built and tested for this page. Enter your data in the yellow cells and the formulas do the rest. They also open in Google Sheets, LibreOffice Calc and Apple Numbers, and each one is set up to print on a single letter-size page for signatures.
Weekly Timesheet & Overtime Pay Calculator
| Day | Time in | Time out | Unpaid break (min) | Hours |
|---|
Runs in your browser; nothing is sent or saved. Check overtime rules for your location.
Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.
What Is an Employee Timesheet?
An employee timesheet is a record of the time a worker spends on the job during a pay period. At minimum it shows the date, the time the employee started, the time they finished and any unpaid breaks in between. Most timesheets also show daily totals, weekly totals and overtime, and they end with a signature line for the employee and an approval line for the supervisor.
Timesheets serve two purposes. First, they are the basis for payroll: hours multiplied by the hourly rate gives gross pay, and overtime is paid at a higher rate. Second, they are a record. In many countries employers must keep accurate records of hours worked by hourly employees, and a signed timesheet is the easiest way to show what was worked and approved if a question comes up later.
Why Use an Excel Timesheet Template?
- Time math is done for you. Subtracting 8:15 AM from 5:45 PM and removing a 30-minute lunch is easy to get wrong by hand. The weekly template converts times to decimal hours with one formula, so 9 hours 30 minutes always shows as 9.50.
- Overtime is separated automatically. You set the overtime threshold once, for example 40 hours a week or 8 hours a day, and the template splits regular and overtime hours.
- Pay is calculated at the right rate. Enter the hourly rate and the overtime multiplier, such as 1.5x, and the sheet shows regular pay, overtime pay and the total.
- Consistent records. Every employee fills in the same layout, which makes approval faster and keeps your payroll files tidy.
- No software subscription. Small teams can run payroll inputs from a spreadsheet and hand the totals to a payroll service or accountant.
Download the Free Employee Timesheet Templates
Each template is hosted on this website and free to download. The preview image shows exactly what you get when you open the file.
1. Weekly Employee Timesheet With Lunch Breaks and Overtime

The weekly timesheet is the classic layout for hourly staff. The top section holds the employee name, employee ID, department and manager, plus four settings: the week starting date, the hourly rate, the weekly overtime threshold and the overtime multiplier. Below that is one row per day from Monday to Sunday, with Time in, Lunch out, Lunch in and Time out.
When you enter the week starting date, the date for every day fills in automatically. The Hours column calculates the time between Time in and Time out, minus the lunch break, and rounds it to two decimal places. The Overtime column keeps a running total for the week and only counts hours above your threshold, so if an employee reaches 40 hours on Friday afternoon, only the hours after that point are marked as overtime. At the bottom you get total hours, regular hours, overtime hours, regular pay, overtime pay and total pay, followed by signature lines for the employee and supervisor.
2. Biweekly Timesheet for Two-Week Pay Periods

Many businesses pay every two weeks. The biweekly timesheet covers 14 days in one sheet, grouped as Week 1 and Week 2. You enter the pay period start date once, and the template fills in all fourteen dates and shows the pay date 18 days after the start of the period, which you can change if your payroll runs on a different schedule.
Instead of clock times, this layout records hours by type: regular hours, overtime hours, sick hours and vacation hours. That makes it a good fit for salaried-but-tracked staff, part-time employees who report total hours, and businesses that need to show paid leave on the timesheet. A daily overtime threshold in the header, set to 8 hours by default, splits each day's hours into regular and overtime. The totals row adds every column, and the pay summary multiplies regular and paid-leave hours by the hourly rate and overtime hours by the rate and multiplier to give gross pay.
3. Monthly Team Hours Tracker

The team hours tracker is built for managers and small business owners. It lists up to eight employees in rows and five weeks in columns, so you can copy each person's weekly total from their timesheet and see the whole month at a glance. The Total hrs column adds the month for each person, and the Overtime column counts every week where that person went over the standard hours you set at the top.
Any employee with overtime is highlighted in pink, which makes it easy to spot workload problems. The team total row shows the hours worked across the business, and the estimated payroll cell multiplies each person's hours by their rate, adding the overtime premium. Use it to check labor costs against your budget before you run payroll, or to plan staffing for the next month.
4. Project Job-Cost Timesheet

Records where the hours went, not just how many. List each job or project in a row and enter the hours for Monday to Sunday; the sheet totals the hours per job and multiplies them by the hourly cost rate. Admin and internal time sit on their own row and are excluded from billable hours, so you can see how much of the week was chargeable. Agencies, contractors and consultants use this to price jobs accurately and to spot projects that run over. Add more job rows as needed.
5. Clock-In / Clock-Out Timesheet

A simple daily punch sheet for shift and hourly staff. Enter the clock-in and clock-out times and the unpaid break in minutes for each day; the sheet works out the hours, including shifts that cross midnight, and the overtime above a daily threshold (8 hours by default). Weekly totals for hours and overtime sit at the top. Some regions require daily overtime as well as weekly overtime, so check your local rules and change the threshold to match. Print it for staff to sign at the end of the week.
How to Fill In the Weekly Timesheet
- Enter the employee details. Type the name, ID, department and manager in the yellow cells at the top.
- Set the week and the pay rules. Enter the Monday that starts the week, the hourly rate, the overtime threshold (40 is common) and the multiplier (1.5 for time and a half).
- Record the times each day. Enter Time in, Lunch out, Lunch in and Time out. Type times such as 8:00 AM or 17:30; Excel will recognize both formats.
- Leave days off blank. If a day has no times, the Hours cell shows 0 and nothing is added to the total.
- Add notes. Use the Notes column for things like a doctor's appointment, a late start or a public holiday.
- Check the totals. Make sure total hours look right and that overtime starts where you expect.
- Sign and approve. Print the sheet or save it as a PDF, and have the employee and supervisor sign it.
Tips for Accurate Timesheets
Accurate timesheets protect both the employer and the employee. A few habits make a big difference:
- Fill it in every day. Hours reconstructed on Friday from memory are rarely accurate. Ask staff to update the sheet at the end of each shift.
- Record actual times, not scheduled times. If someone starts at 8:07 AM, record 8:07 AM. Decide on a rounding rule, such as to the nearest quarter hour, and apply it the same way for everyone.
- Agree on breaks. Short rest breaks are usually paid, while longer meal breaks are often unpaid. The weekly template subtracts only the lunch break you record, so make sure everyone knows the rule.
- Approve on time. Have a supervisor review and sign timesheets before the payroll cut-off. Corrections are much easier before pay goes out.
- Keep copies. Store signed timesheets with your payroll records for as long as your local rules require.
Overtime Rules: What to Check
Overtime rules depend on where you operate. In the United States, the federal rule for most non-exempt employees is overtime at one and a half times the regular rate for hours over 40 in a workweek, and some states add daily overtime rules. Other countries use different thresholds or daily limits. That is why both the weekly and biweekly templates let you set the threshold and the multiplier yourself instead of hard-coding them. If you are unsure which rule applies, check with your local labor department or a payroll professional before you rely on the numbers.
Timesheet vs. Time Card vs. Attendance Sheet
These terms are often used interchangeably, but they are slightly different. A time card traditionally records punch-in and punch-out times from a time clock. A timesheet records the hours worked and is usually filled in and signed by the employee. An attendance sheet only records whether someone was present, absent, late or on leave, without calculating pay. The templates on this page are timesheets: they record hours and turn them into pay.
How to Use These Templates in Google Sheets
Upload the .xlsx file to Google Drive, right-click it and choose Open with Google Sheets. All formulas, formatting and the print area carry over. You can then share the sheet with an employee so they can fill in their own hours, and give the supervisor comment access to approve. To keep a clean master copy, save a copy of the blank template for each new pay period.
You can also check these important templates like the timesheet calculator template for quickly converting clock times to hours, and the payroll templates for turning approved hours into net pay.
You may also like the weekly time schedule template for planning shifts before the week starts, and the daily schedule template for organizing tasks within the working day.
Frequently Asked Questions
What is the best timesheet template for hourly employees?
For most hourly staff the weekly employee timesheet works best, because it records clock-in, lunch and clock-out times for each day and calculates hours, overtime and pay automatically.
How does the template calculate hours from clock times?
It subtracts Time in from Time out, removes the lunch break, multiplies the result by 24 to convert Excel time into hours, and rounds it to two decimals. Nine and a half hours shows as 9.50.
Can I change the overtime threshold?
Yes. Enter your own weekly threshold in the weekly template or your own daily threshold in the biweekly template, and set the multiplier, such as 1.5 or 2.0.
Do these timesheet templates work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas, colors and print layout all work.
How long should I keep employee timesheets?
Keep signed timesheets with your payroll records for at least as long as your local labor and tax rules require. Many employers keep them for several years.
