Free Excel template
Free Excel timesheet template
For hourly workers, freelancers and small teams who need a simple weekly timesheet. Enter start, end and break times as decimal hours (8.5 means 8:30 AM, 17.25 means 5:15 PM); the template works out hours worked per day, splits the week into regular and overtime hours, and calculates pay.
Preview and try it
This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Date | Day | Start | End | Break (hrs) | Hours worked |
| 2 | Nov 2, 2026 | Mon | 8.5 | 17 | 0.5 | 8 |
| 3 | Nov 3, 2026 | Tue | 8.5 | 17.5 | 0.5 | 8.5 |
| 4 | Nov 4, 2026 | Wed | 9 | 18.25 | 0.75 | 8.5 |
| 5 | Nov 5, 2026 | Thu | 8 | 16.5 | 0.5 | 8 |
| 6 | Nov 6, 2026 | Fri | 8.5 | 19 | 0.5 | 10 |
| 7 | Nov 7, 2026 | Sat | 10 | 14 | 0 | 4 |
| 8 | 46334 | Sun | ||||
| 9 | ||||||
| 10 | Employee | Jordan Reyes | Total hours | 47 | ||
| 11 | Week starting | Nov 2, 2026 | Regular hours | 40 | ||
| 12 | Overtime hours | 7 | ||||
| 13 | ||||||
| 14 | Hourly rate | 24.5 | ||||
| 15 | Overtime after (hrs/week) | 40 | ||||
| 16 | Overtime multiplier | 1.5 | ||||
| 17 | ||||||
| 18 | Regular pay | 980 | ||||
| 19 | Overtime pay | 257.25 | ||||
| 20 | Total pay | 1237.25 |
How the formulas work
Hours worked per day
End minus start, minus the break. MOD(...,24) handles a shift that runs past midnight: 22 to 6 gives 8 hours instead of -16. MAX(0,...) stops a typo (a break longer than the shift) from producing negative hours, and the IF leaves days off blank.
Dates and weekday names fill themselves
Type the Monday of the week in A2; each row below adds one day (=A2+1). TEXT with "ddd" shows the short weekday name, so you can see at a glance which day each row is. Use "dddd" for the full name.
Split regular and overtime hours
Anything above the weekly limit in F15 counts as overtime; MAX keeps it at zero in a short week. Regular hours in F11 are MIN(F10,F15), so the two always add up to the total. In the US, federal law requires overtime pay after 40 hours in a workweek, and some states (California, for example) also have daily overtime rules, so check yours.
Pay with an overtime multiplier
Overtime hours times the hourly rate times 1.5, rounded to cents. Change F16 to 2 for double time. Total pay in F20 adds regular and overtime pay.
Make it yours
- Minutes to decimals: divide the minutes by 60. 15 minutes = .25, 30 = .5, 45 = .75, so 1:45 PM is 13.75.
- Already have real clock times in Excel (like 8:30 AM)? Multiply the difference by 24 to get decimal hours:
=(D2-C2)*24. Excel stores times as fractions of a day. - Make a copy of the sheet for each week (right-click the tab > Move or Copy > Create a copy) and just change the date in A2.
- If your workplace rounds punches to the nearest quarter hour, round the hours instead with
=MROUND(value,0.25)or=ROUND(value*4,0)/4.
FAQ
How do I calculate hours worked in Excel?
Subtract the start from the end and take off the break. With decimal hours, =D2-C2-E2 gives hours directly. With real time values, multiply the difference by 24 to turn a fraction of a day into hours.
How do I handle a night shift that ends after midnight?
Wrap the subtraction in MOD: =MOD(end-start,24) for decimal hours. When the end is smaller than the start, MOD adds 24, so 22 to 6 gives 8 hours.
How do I calculate overtime in Excel?
Overtime is the part of the total above the limit: =MAX(0,total-40). Regular hours are =MIN(total,40). Multiply overtime by the rate and the overtime multiplier, usually 1.5.
Functions used
IFPicks a result from a testMAXLargest numberMINSmallest numberROUNDRounds to digitsMODRemainder after divisionSUMAdds numbersTEXTNumber to formatted text
Related guides
- Excel IF statement with multiple conditions
- Absolute vs relative cell references in Excel
- ##### in Excel: why it happens and how to fix it
More free templates
- Expense report templateFor employees who need to claim back business costs, and for the managers and bookkeepers who check those claims.Free .xlsx
- Purchase order templateFor small businesses, office managers and buyers who send purchase orders to suppliers and want to track what actually arrives.Free .xlsx
- Accounts receivable aging report templateFor owners, bookkeepers and credit controllers who invoice customers on terms and need to see who owes what and for how long.Free .xlsx
- Weekly employee shift schedule templateFor managers of shops, cafes, restaurants and small teams who build the rota in a spreadsheet.Free .xlsx
Updated