What it's for
- A project manager tracking who spent what on one project.
- Teams working to an hours budget.
- Handing a client or sponsor a simple hours-by-person summary.
What's inside
- How to use
- Short instructions and the colour key.
- Project
- Project name, client and budget in hours; hours logged, hours left and the share of the budget used; and each person's hours and share of the total.
- Log
- One row per piece of work: date, person, task and hours. People come from a dropdown.
Preview
| Date | Person | Task | Hours |
|---|---|---|---|
| 1 Mar 2027 | Sam | Wireframes | 6 |
| 1 Mar 2027 | Priya | Content outline | 5 |
| 2 Mar 2027 | Sam | Wireframes | 4.5 |
| 2 Mar 2027 | Alex (not on the people list) | Kickoff | 3 |
18.5 hours are logged, 101.5 are left, and 15.4% of the budget is used. Sam has 10.5 hours (57% of the total) and Priya 5.0. Alex is not on the list, so Alex's 3.0 hours show on the "Not on the list" line.
How to use it
- On Project, type the project, the client and the budget in hours (or leave the budget blank).
- List each person once in the Person column on Project.
- In the Log, add a row for each piece of work: the date, the person (from the list), the task and the hours as decimals.
- Read the Project sheet: hours logged, hours left, budget used and each person's share.
- Check the "Not on the list" line is 0, or add the missing person.
The formulas, explained
- Hours logged
-
=SUM('Log'!D4:D503)Adds up every hour in the Log.
- Budget used
-
=IF(OR(B5="",N(B5)=0),"",B6/B5)Hours logged divided by the budget. Blank until you type a budget.
- Hours for a person
-
=SUMIFS('Log'!$D$4:$D$503,'Log'!$B$4:$B$503,$A11)Adds up the Log's hours for that person.
- Not on the list
-
=B6-SUM(B11:B40)Hours logged by people who are not on the list, so nothing goes missing.
Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.
Questions
Can I track more than one project?
Use one copy of the file for each project. If you want hours across several clients and projects, use the agency timesheet or the consultant timesheet.
Does it track cost or money?
No. It is hours only. The project budget tracker template turns hours into value with a rate for each role.
How many people can I list?
30 people. The Log has 500 rows.
How is this different from the agency timesheet?
That one is organised by client and week with a rate on each project. This one is a single project, organised by person, with an hours budget.
Does it work in Google Sheets?
Yes. Upload it with File > Import in Google Sheets. It only uses functions both programs have (IF, OR, N, SUM and SUMIFS). 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.