What it's for
- A manager or bookkeeper who collects the team's hours each week.
- Small teams that do not need a timesheet for each person.
- Seeing hours for the whole team, with who is over a limit, in one view.
What's inside
- How to use
- Short instructions and the colour key.
- Team week
- Week start, your hours limit and the approver; 30 employee rows with hours for each day from Monday to Sunday; total hours, hours over the limit and hours up to the limit for each person; and team totals.
Preview
| Employee | Mon | Tue | Wed | Thu | Fri | Sat | Total | Over limit |
|---|---|---|---|---|---|---|---|---|
| Sam | 8 | 8 | 8 | 8 | 8 | 40.00 | 2.00 | |
| Priya | 7.5 | 7.5 | 7.5 | 7.5 | 30.00 | 0.00 | ||
| Alex | 8 | 8 | 8 | 8 | 8 | 4 | 44.00 | 6.00 |
The team worked 114.00 hours: 8.00 are over the limit and 106.00 are up to it. The limit of 38 hours is an example: you choose yours, or leave it blank to split nothing out.
How to use it
- Type the first day of the week and, if you split hours over a limit, the hours in a week before overtime. You choose the limit.
- Type each employee once in the first column.
- Type the hours each person worked each day, as decimals (7 hours 45 minutes is 7.75). Leave days off blank.
- Read each person's total and the team totals at the bottom.
- Print the sheet, sign it and pass it on.
The formulas, explained
- Total hours
-
=IF($A8="","",SUM(B8:H8))Adds up the person's seven days.
- Over the limit
-
=IF(OR($A8="",N($B$4)<=0),"",MAX(0,I8-$B$4))Total hours past the limit you typed. Blank until you type a limit.
- Up to the limit
-
=IF($A8="","",I8-N(J8))Total hours less the hours over the limit.
Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.
Questions
Does it work out hours from start and finish times?
No. It takes hours for each day, which you work out first. For start and finish times, use the weekly timesheet for each person.
How many employees fit?
30 rows. Use a second copy for a bigger team.
Can I use it for a fortnight?
Use one copy for each week, or the fortnightly timesheet for one person.
What limit should I type?
The file does not suggest one. It depends on the contract, award or agreement, and the country. Leave it blank if you only want the hours.
Does it work in Google Sheets?
Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, OR, MAX, N and SUM). It also opens in LibreOffice.
About this template
Last reviewed 15 November 2026.
Changes: 15 November 2026: first published.
Free to use and change in your own business. Please don't resell the files or publish them as your own. More free templates.