You can work a long day and still have no idea how many hours belonged to paying client projects. A freelance time tracking spreadsheet makes that distinction visible by recording each work session, breaks, billable status, and estimated value. It is particularly useful when you quote flat fees but still need to learn whether your projects are profitable.
This guide includes a free editable Excel workbook with a time log and dashboard, formulas that handle overnight sessions, a worked example, and a simple weekly review. It is designed for independent contractors and solo professionals, not as a substitute for payroll compliance or a timekeeping system required by an employer.
Download: Free Freelance Time Tracking Spreadsheet (.xlsx). The workbook contains fictional example rows you can replace; Excel and compatible spreadsheet applications can edit it.
Quick takeaways
- Log time by client, project, task, start, end, break, and billable status.
- Calculate hours rather than estimating from memory at invoice time.
- Separate billable and non-billable hours to understand capacity and pricing.
- Compare the dashboard with your contract before invoicing—tracked time and invoiceable time are not always identical.
Why use a time tracking spreadsheet as a freelancer?
Time records answer three different questions. Operations: where did your working hours go? Pricing: how many hours did the deliverable actually require? Billing: how much time can you charge according to the agreement? Those are related questions, but not identical.
For example, a two-hour consultation might be fully billable. One hour spent preparing your own invoices is usually an internal administrative activity. A second round of revisions on a fixed-fee project might be included in the agreed price rather than invoiced as extra hours. The tracker should record effort honestly even when it is not separately charged.
Recording non-billable work helps answer whether a proposed hourly rate is sustainable. If you assume forty chargeable hours per week but actually spend a significant share on outreach, paperwork, and learning, the rate calculation needs to account for that reality. See our freelance hourly rate calculator for pricing context.
Download the free editable timesheet
The workbook contains three sheets:
- Read Me: how to edit the sample data and understand the formulas.
- Time Log: 200 ready-to-fill rows for dates, tasks, times, breaks, billable status, hourly rate, and value.
- Summary: total hours, billable hours, non-billable hours, utilization, and estimated billable revenue.
The spreadsheet has no account registration or software subscription requirement. It is an ordinary Excel file; formulas should also be understandable in Google Sheets after import, though you should test date and time formatting because locales can differ.
Download the freelance timesheet workbook
Replace the fictional examples before using the file for real billing. Store client names and project details securely; do not put confidential work descriptions into publicly shared spreadsheets.
Timesheet columns and spreadsheet formulas
| Column | Field | Use |
|---|---|---|
| A | Date | When the work occurred |
| B | Client / Project | The customer or internal project |
| C | Task | Specific work performed |
| D | Start | Session start time |
| E | End | Session end time |
| F | Break (min) | Unworked minutes during session |
| G | Billable? | Yes or No, according to agreement |
| H | Hours Worked | Calculated decimal hours |
| I | Billable Hours | Calculated chargeable time |
| J | Rate / Hour | Illustrative or agreed rate |
| K | Estimated Value | Calculated billable value |
1. Calculate hours worked, including breaks
In H5 the downloadable template uses this formula:
=IF(OR(D5="",E5=""),"",MAX(0,MOD(E5-D5,1)*24-F5/60))Spreadsheet time values are fractions of a day, which is why multiplying by 24 converts them into hours. MOD lets an end time after midnight be later than a start time on the previous evening. Subtracting break minutes divided by 60 avoids counting a lunch break as work.
For example, a session from 9:00 a.m. to 11:30 a.m. with a 15-minute break is 2.25 hours, not 2.5 hours. The formula guards against negative results, but you must still verify the original times and breaks are accurate.
If you work for more than 24 continuous hours or track travel across time zones and daylight-saving changes, a simple time-only formula may not be suitable. Store complete date-time values and use a specialized record in those cases.
2. Count billable hours separately
=IF(H5="","",IF(G5="Yes",H5,0))Place this in I5. Administrative work marked No remains visible in Hours Worked but contributes zero Billable Hours. If you agreed that a client meeting is billable, mark it Yes. The spreadsheet should reflect the written contract, not an arbitrary preference to invoice every minute.
3. Estimate the value of tracked time
=IF(I5="","",I5*J5)This formula multiplies billable hours by the rate. It is an estimate, not an invoice total: taxes, discounts, caps, retainers, project deposits, and contract-based rounding rules may change the amount actually due. A fixed-fee agreement requires a different billing reconciliation.
Worked example: four sessions in two days
These figures are fictional and illustrate how the spreadsheet treats billable and non-billable work.
| Task | Hours worked | Billable? | Hourly rate | Estimated value |
|---|---|---|---|---|
| Homepage layout | 2.25 | Yes | $75 | $168.75 |
| Own invoice administration | 0.75 | No | — | $0.00 |
| Landing page copy | 2.00 | Yes | $90 | $180.00 |
| Client revision call | 0.50 | Yes | $75 | $37.50 |
Total hours worked are 5.50. Billable hours are 4.75. Estimated billable value is $386.25. Billable utilization for this small sample is 4.75 ÷ 5.5, or about 86.4%.
Do not mistake this illustrative utilization for a normal long-term target. Sales, administration, professional development, and rest are necessary parts of freelance work. Compare your own utilization across several weeks before changing prices or capacity assumptions.
A 15-minute weekly review for better project pricing
Minutes 0–5: check for missing sessions
Review the calendar, project files, and call records for work that was performed but not entered. Avoid retroactively inventing precise times. If an entry is an estimate, mark it accordingly so billing decisions remain transparent.
Minutes 5–10: compare planned and actual effort
Group sessions by project and examine the difference between estimated and actual hours. A fixed-price design project quoted at ten hours that repeatedly consumes fifteen hours may need a better briefing process or revised future price. It does not automatically entitle you to charge the current client more.
For scope-related overruns, refer to our freelance change-control guide. For revised pricing estimates, review the project quote calculator.
Minutes 10–15: prepare invoice evidence
Check what the agreement permits: hours, daily rate, fixed-fee milestones, included meetings, rounding rules, and expense treatment. Export a clean client-specific timesheet if requested. Keep confidential internal work and other clients out of any shared report.
Some freelancers track time in 6-minute or 15-minute billing increments, but you should never silently apply rounding that your contract does not authorize. Choose and document the agreed approach before billing.
Billable utilization is helpful, but not a complete success metric
Utilization means billable hours divided by all hours worked for a defined period. It can reveal growing administrative overhead or a poor balance of client and internal tasks. It does not tell you profit by itself: expenses, unpaid time, taxes, fixed-fee revenue, and client acquisition still matter.
For a simple project profitability check, calculate project revenue minus direct project expenses, then divide the remainder by all project hours, including non-billable revisions and meetings. That gives a more realistic effective return per hour than the posted client rate.
Use the timesheet alongside the freelance business expenses checklist and cash-flow management guide rather than treating the hours log as a complete financial system.
Eight common freelancer time tracking mistakes
- Writing entries at the end of the month. Memory makes details less reliable. Record sessions promptly.
- Calling every working hour billable. Sales and business administration are often internal work.
- Forgetting breaks. Use realistic session start, end, and break values.
- Mixing client projects. Each row should identify the correct project and task.
- Rounding without authorization. Follow the agreement and disclose the billing rule.
- Ignoring fixed-fee work. Track hours even when you invoice milestones, to improve future estimates.
- Treating estimates as a financial record. Reconcile approved hours, rate, expenses, and payments.
- Sharing confidential task descriptions. Separate internal notes from client-facing reports.
A spreadsheet is often enough for a solo freelancer or a small number of recurring clients. If the number of staff, clients, or compliance requirements grows, a dedicated tool may make sense—but it should be chosen because the workflow needs it, not because a dashboard looks attractive.
Frequently asked questions
Can I track freelance hours for free in Excel?
Yes. A spreadsheet can track project, date, start and end times, breaks, billable status, hours, and estimated value. Use the editable workbook linked above and replace its example rows.
What is the formula for hours worked in a timesheet?
For spreadsheet time cells, a common approach is MOD(end-start,1)*24 minus unpaid break minutes divided by 60. Check how your spreadsheet handles overnight sessions and date values.
What counts as billable freelance time?
Billable work is time or activity your client agreed to pay for. Meetings, revisions, planning and research may or may not be billable depending on the written terms. Record non-billable work separately.
How do I calculate billable utilization?
Divide billable hours by total worked hours for the same period, then multiply by 100. A freelancer who tracks 4.75 billable hours out of 5.5 worked has about 86.4% utilization for that period.
Should I use time tracking on fixed-price projects?
Yes. Recording actual hours helps evaluate whether your fixed fee covers the effort. It does not automatically change the price owed under the existing agreement.