Project Time Tracker

Log team hours against client projects, compare them with budgeted hours, and see billable value and remaining budget per project.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Trackers

Tables

Projects, Time Logs

Fields

21

Views

grid, dashboard, calendar, form

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Projects

12 fields · 3 sample rows

  • Projects (Grid)
  • Budget health (Dashboard)
ProjectTextClientTextStatusSingle selectBudget hoursNumberHourly rateCurrencyDeadlineDateTime logsLink to another tableHours loggedRollupBillable hoursRollupHours remainingFormulaBudget usedFormulaBillable valueFormula
Brand refreshChai PointActive120₹3,0009 Dec 2026Logo concepts round 2, Client feedback call7.071136%₹21,000
E-commerce appFabindiaActive400₹3,5002 Feb 2027Cart & checkout screens, Payment gateway spike, Internal sprint planning, Regression testing16.014.53844%₹50,750
SEO auditNordic Living ABCompleted30₹4,0009 Nov 2026Final audit report8.082227%₹32,000
Field details
Project · Text
Client · Text
Status · Single select
Active, On hold, Completed
Budget hours · Number
Hourly rate · Currency
INR
Deadline · Date
Time logs · Link to another table
Links to Time Logs
Hours logged · Rollup
sum of Hours via Time logs
Billable hours · Rollup
sum of Billable hours via Time logs
Hours remaining · Formula
{Budget hours} - {Hours logged}
Budget used · Formula
IF({Budget hours} > 0, {Hours logged} / {Budget hours}, BLANK())
Billable value · Formula
{Billable hours} * {Hourly rate}

Time Logs

9 fields · 7 sample rows

  • Timesheet (Grid)
  • Calendar (Calendar)
  • Log time (Form)
  • Team utilisation (Dashboard)
DescriptionTextProjectLink to another tableTeam memberSingle selectDateDateActivitySingle selectHoursNumberBillableCheckboxBillable hoursFormulaNotesLong text
Logo concepts round 2Brand refreshAnanya16 Nov 2026Design6.0Yes6
Client feedback callBrand refreshVikas17 Nov 2026Meetings1.0Yes1
Cart & checkout screensE-commerce appRohit17 Nov 2026Development7.5Yes7.5
Payment gateway spikeE-commerce appElena18 Nov 2026Research4.0Yes4
Internal sprint planningE-commerce appVikas18 Nov 2026Project management1.50
Final audit reportSEO auditElena7 Nov 2026Research8.0Yes8
Regression testingE-commerce appRohit19 Nov 2026QA3.0Yes3
Field details
Description · Text
Project · Link to another table
Links to Projects
Team member · Single select
Ananya, Rohit, Elena, Vikas
Date · Date
Activity · Single select
Design, Development, Meetings, Research, QA, Project management
Hours · Number
Billable · Checkbox
Billable hours · Formula
IF({Billable}, {Hours}, 0)
Notes · Long text

Form view “Log time” asks for: Description, Project, Team member, Date, Activity, Hours, Billable, Notes.

Project Time Tracker: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates