Freelancer Time Tracker

Freelancer Time Tracker — Every Billable Hour, Counted and Priced

Freelance hours slip away unnoticed: a half hour here, an hour there, and Friday arrives with no record of what the week was actually worth. This tracker logs every work session once — date, client, start and end — and turns it into billable hours, amounts per client and a weekly total, so invoicing takes minutes instead of guesswork.

Log a session and the sheet works out the hours from your start and end times, looks up the client's rate, and prices the session for you. Mark it billable or not — admin and learning time stays in the log but out of the bill — and a weekly view shows hours and amount per week so you always know what the week earned.

What you get:

• Time Log — every session with date, client, project, task, start, end, hours, billable?, rate, amount and week (Monday)
• Clients — every client with hourly rate, hours, billable hours, amount and entries
• Summary — entries, clients, total hours, billable hours, non-billable hours, billable %, total amount, average llable rate, top client, weeks in the log, average hours per week
• Weekly — per-week hours, billable hours, amount and running amount
• README sheet — 5-minute setup guide, no macros, no add-ins

How it works: Yellow cells are the only ones you type in. Everything else is a formula. Hours are worked out from start and end times; the rate is looked up automatically from the Clients sheet — change a rate once and every session for that client updates. Mark each session Billable? Yes or No and the billable totals update themselves. Works in Microsoft Excel 2016 and newer, and in Google Sheets (File > Import > Upload). No sign-in, no subscription, no macros.

Who it is for: Freelancers who bill by the hour and want Friday invoicing to take minutes — instead of reconstructing the week from memory and chat history.

You get: 1 Excel file (.xlsx), 5 sheets, instant download. For personal use only.