Project timesheet for one project and many people

Everyone logs time to one project. The sheet totals the hours, shows each person's share and tells you how much of the hours budget is left.

  • No email needed
  • Last reviewed 15 November 2026

For Google Sheets, download the .xlsx and open it with File > Import.

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

Worked example: a project with a budget of 120 hours
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

  1. On Project, type the project, the client and the budget in hours (or leave the budget blank).
  2. List each person once in the Person column on Project.
  3. 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.
  4. Read the Project sheet: hours logged, hours left, budget used and each person's share.
  5. 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.

Track this in Jasper

Log hours by client and project, approve timesheets and follow retainer hours, next to your team chat.

Want this by email?

Entirely optional. Everything on this page works without an email address.

Sent by Shakewell Agency Pty Ltd, Sydney, Australia. Every email has an unsubscribe link. Privacy policy.