Skip to content
Project Hours Tracker cover: a sample sheet with budgeted hours, logged hours and hours left and a bar chart, beside the Dashboard, Projects and Time log tabs

Project Hours Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Project Hours Tracker suits consultants, agencies and internal teams that work to a fixed number of hours per project. The Projects tab holds the budget and deadline for each job, while logged hours and hours left fill in from the Time log. The Dashboard compares budget with logged hours by project and shows hours by team member, with the billable share as a percentage.

Give each project a realistic budget before the work starts, and review the used percentage every Friday. Projects that go over budget turn red on the Projects tab. Mark the Billable column honestly, because it drives the billable share that managers often check against a target. To rename a project, change it on both the Projects tab and the Project list on the Time log.

Useful for

  • Track hours against a fixed project budget
  • Show a client how much of the budget is used
  • See how billable time splits across the team

What's included

  • 4 tabs: Dashboard, Projects, Time log, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Projects: a table
  • Time log: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Projects tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I make a new project available in the Time log?

Type the project name on the next empty row of the Projects tab, then add its budget and deadline. Enter the identical name in the Time log Project list, which is editable under Data validation. Logged hours and percent used fill in as soon as you log time against it.

What does the billable share measure?

It is the hours marked Yes in the Billable column as a share of all hours logged. It is a simple ratio, not a fee calculation. Use it to see how much of the team's time is charged to clients compared with internal work.

How do I log time in quarter hours?

Enter time as decimals, so 15 minutes is 0.25 hours and 1 hour 20 minutes is 1.33. If your team prefers minutes, log minutes in a spare column and divide by 60 before adding the totals to the Hours column.

  • #timesheet
  • #project-hours-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More timesheet templates

See all 10

Also in Human resources

All human resources templates
Get this template

Preparing your template…