Skip to content
26 Excel templatesShop Templates
AutoExcel

How to Make a Timesheet in Excel with Overtime

Published 2026-11-18

A weekly timesheet in Excel can total the hours, split off the overtime and work out the pay, so nobody does it by calculator at the end of the week.

1. Lay out the week

Put project or task names down the left, and the days Monday to Sunday across the top. Enter the hours worked as decimal numbers (for example 7.5 for seven and a half hours) in the cells.

Add the week's starting date in one cell. Fill the day headings from it, so the dates update when you change the week.

Date for Tuesday (start date in C3, Monday heading in C5)
=C3+1

2. Total each day and the week

With hours in rows 6 to 17, the Monday column is column C:

Daily total (copy across)
=SUM(C6:C17)
Weekly total
=SUM(C18:I18)

3. Split regular and overtime hours

Enter the regular hours per day (for example 8) in a settings cell, such as J8. For overtime that applies to hours over the daily limit:

Regular hours for a day (daily total in C18)
=MIN(C18,$J$8)
Overtime hours for a day
=MAX(0,C18-$J$8)

4. Calculate pay

Put the hourly rate in J7 and the overtime multiplier (1.5 for time and a half) in J9. Total regular hours are in J19 and total overtime hours in J20.

Regular pay
=ROUND(J19*J7,2)
Overtime pay
=ROUND(J20*J7*J9,2)
Total pay
=J21+J22

Check your overtime rules

Overtime rules differ. Some apply after a number of hours in a day, some after a number of hours in a week, and some differ for holidays or particular agreements. Make sure the formulas follow the rules that apply to you, and treat the result as gross pay before deductions, not a payroll calculation.

Printing and approval

Set the print area to one page, and leave lines for the employee and supervisor to sign and date. Use a fresh copy of the sheet for each person each week.

More guides

Templates for this job

Ready-made Excel workbooks. No macros, instant download.

Business Tools

Weekly Timesheet

A printable weekly timesheet with overtime and pay calculated for you.

$15.00
Details