Google Sheets Time Tracker: The Setup That Shows You Exactly What Your Hours Are Worth

Most freelancers and remote workers are undercharging. Not because they're bad at negotiating, but because they have no idea how long things actually take. You quote a project based on a gut feel, deliver it, get paid — and never calculate your effective hourly rate. If you did, you'd often find it's half what you thought.

Time tracking fixes this. Not because it makes you work faster, but because it forces you to see the truth. Once you know a certain type of client or project consistently pays $12/hour in practice, you either reprice it or stop taking it. That's the leverage.

Here's how to build a Google Sheets time tracker that gives you that visibility — with formulas that handle the math automatically.

---

Why Freelancers Who Track Time Earn More

The mechanism is simple: tracking time creates accountability to your own rates.

When you log hours, you see your effective hourly rate on every project. You notice that the "quick" website update took 6 hours, not 2. You notice that one client always scopes poorly and ends up being your worst-paying work. You notice that your retainer clients, even at lower rates, have zero scope creep and high effective rates.

None of this is obvious without data. With data, your next proposal is smarter — because it's based on reality, not optimism.

---

The 5-Column Time Log Setup

Keep your time log minimal. These five columns capture everything that matters:

| Column | Header | Notes | |--------|--------|-------| | A | Date | Date of work session | | B | Client | Client or company name | | C | Project | Short project descriptor | | D | Hours | Duration (decimal or time) | | E | Rate | Hourly rate for this work |

Add a sixth column:

| F | Amount | =D2*E2 |

This auto-calculates the billing value for every row. No manual math. As you add entries, column F tells you exactly what each session was worth.

For rate, you can either:

1. Enter the rate per row (useful if rates vary by client or project type)
2. Create a rates lookup table on a second sheet and use VLOOKUP to pull the rate by client name automatically

Start with option 1 for simplicity. Switch to option 2 when you have more than 5–6 clients at different rates.

---

The Start/Stop Time Formula

If you want more precision than entering decimal hours, use a Start and Stop column instead of a single Hours column:

| Column | Header | |--------|--------| | A | Date | | B | Start Time | | C | Stop Time | | D | Duration |

For column D, use this formula to calculate elapsed hours from start and stop times:

=TEXT(C2-B2,"[h]:mm")

Enter start and stop times using Google Sheets time format (e.g., 9:00 AM, 2:30 PM). The [h]:mm format handles sessions longer than 24 hours and returns duration as hours and minutes — e.g., 1:45 for 1 hour 45 minutes.

If you need the duration as a decimal for billing calculations, use:

=(C2-B2)*24

This converts the time difference to a decimal number (e.g., 1.75 for 1 hour 45 minutes), which you can multiply directly against your hourly rate in the Amount column.

---

Free resource: Grab our free Notion starter template → notioncraft.madethis.app/free

---

Building the Weekly Summary Tab with SUMIF

The raw time log is your data. The summary tab is where it becomes actionable.

Create a second tab called "Weekly Summary" with:

| Column | Header | |--------|--------| | A | Week Starting | | B | Client | | C | Hours | | D | Amount |

Then use SUMIFS to pull totals from your time log by week and by client:

=SUMIFS('Time Log'!D:D, 'Time Log'!A:A, ">="&A2, 'Time Log'!A:A, "<"&(A2+7), 'Time Log'!B:B, B2)

Where A2 is the week start date and B2 is the client name. This pulls all hours logged for that client in a 7-day window.

For a simpler monthly view, add a helper column to your time log that extracts the month:

=TEXT(A2,"YYYY-MM")

Then use SUMIF against that column:

=SUMIF('Time Log'!G:G, "2026-06", 'Time Log'!F:F)

This gives you total billing value for June 2026 in one cell. Change the month string and you have your monthly total for any period instantly.

Effective Hourly Rate View

Add one more calculation to your summary that most freelancers never look at: effective hourly rate by client.

In your monthly or client summary, add a column:

=D2/C2

Where D2 is total amount earned from the client and C2 is total hours logged. This shows you your real hourly rate for each client — not the rate you quoted, but the rate you actually achieved after scope creep, revisions, and admin time.

Sort by this column once a quarter and you'll know exactly which clients are worth keeping and which need a rate conversation.

---

The Weekly Review Habit

A time tracker only works if you update it. The failure mode is logging for three weeks, getting busy, skipping a week, and then trying to reconstruct time from memory. That defeats the purpose.

Build the update into your existing weekly ritual:

1. Log every session same-day or next-day — don't batch more than 24 hours of entries at once. Memory degrades fast.
2. Review your weekly summary every Friday — 5 minutes to check your total billable hours and total amount earned. Are you on track for your monthly income goal?
3. Run a monthly client review — check your effective hourly rate per client. Who's your best-paying work? Who consistently underperforms the quoted rate?

The data compounds over time. Six months of consistent tracking gives you real pricing intelligence.

---

Time Tracking and Income Tracking Are Two Sides of the Same System

Your time tracker tells you what you should have earned. Your income tracker tells you what you actually received. Both numbers matter.

If your time log says you billed $4,200 in June but your income log shows $3,100 received, you have $1,100 outstanding — and you know exactly which invoices to chase. Without both, you're guessing at your own financial position.

A combined setup — time log, invoice tracker, income log — is what turns freelancing from financial chaos into something you can actually plan around.

---

Stop Guessing What Your Time Is Worth

The Personal Finance Tracker (Google Sheets) handles the income side of this equation — log every payment received, auto-calculate your tax set-aside, and see your monthly cash flow at a glance. Pair it with the time log you just built and you'll have the full picture: hours worked, amount billed, amount received, and what you owe in taxes.

Get the Personal Finance Tracker →

One-time purchase, $19. Works in Google Sheets. Takes about 10 minutes to set up alongside your existing workflow.