Google Calendar time tracking: billable hours without a timer
Most time trackers ask you to press start and stop. Many freelancers forget, then rebuild the week from memory on Friday. If your work already lives in Google Calendar, there is a simpler habit: plan the time in the calendar, correct it when the meeting ends, and count from the calendar. This guide explains the method, what Google Calendar can and cannot do on its own, and the mistakes that make totals wrong.
What Google Calendar does and does not track
Google Calendar records when an event starts and ends. It does not add those durations up for you in a personal Google account. Two settings are often mistaken for time tracking:
- Working hours (Settings, then General, then Working hours and location) tells other people when you are available. It does not measure anything.
- Time insights shows how your time splits between meetings and focus time, but only in some Google Workspace business, enterprise and education editions, and only for your own calendar.
So the calendar holds the raw material. To bill from it, you need a way to say which client each event belongs to, and a way to add the hours up.
The calendar-first method in four steps
1. Plan the work as events
Put client work in the calendar before you do it: calls, workshops, but also the focused blocks where you write, design or code for a client. An event with a start, an end and a clear title is already a time entry.
2. Correct the event when it ends
Meetings overrun and blocks get cut short. Drag the end of the event to the real end time while you still remember it, or at the end of each day. This one habit replaces the timer: the calendar ends up showing what happened, not only what was planned.
3. Tag each event with its client
Choose one convention and keep it:
| Tag | Works well when | Limit |
|---|---|---|
| An event colour per client | You have a handful of clients and plan visually. | Google offers 11 event colours. |
| A calendar per client | You have many clients or share a calendar with one. | More calendars to keep visible. |
| A word in the title, like "Acme: review" | You add events from your phone. | A typo means a missed event. |
| The guest's email domain | Client meetings come with invitations. | Solo work has no guests. |
The guide to counting hours by client compares the four in more detail.
4. Count the hours at the end of the month
You can count by hand, with a formula in Google Sheets, or automatically. The timesheet guide shows the first two step by step. Whatever the method, count from the calendar once, at a fixed moment, so the total does not change after you have invoiced.
Five mistakes that make calendar totals wrong
- Declined and cancelled invitations. They can stay visible in your calendar. Leave them out of the count.
- All-day events. A holiday or a deadline marked all day is not 24 billable hours.
- The same meeting in two calendars. A meeting in your work calendar and in a shared client calendar must count once.
- Events across midnight or the end of the month. Only the part inside the month belongs on that month's invoice.
- Changing past events after invoicing. Close each month once, keep that version, and record later corrections as additions.
Timer app or calendar: which one?
| Timer app | Calendar-first | |
|---|---|---|
| Daily effort | Start and stop for each task | Adjust the end of events |
| Forgotten entries | Common: the timer was not started | Rare: the work was planned |
| Short tasks and interruptions | Precise to the minute | Usually rounded to blocks |
| Where the data lives | In the timer service | In your calendar and your own sheet |
If you switch between many small tasks every hour, a timer is more precise. If your billable work is mostly meetings and planned blocks, the calendar already holds better data than you would type into a timer.
Questions
Does this work with a free Gmail account?
Yes. Events, colours, calendars and guests work the same way in a personal Google account and in Google Workspace. Only Time insights is limited to some Workspace editions.
How precise should the events be?
As precise as you bill. If you round each meeting up to 15 minutes, correcting the end time to the nearest 5 minutes is enough. The billing guide covers rounding and minimum charges.
Can I get the hours into a spreadsheet automatically?
Yes. The export guide compares the built-in export, a small script and an add-on that updates the sheet every hour.
Count every hour from your calendar, automatically
Calendar Timesheet applies the method above for you: it reads your calendars every hour, recognises clients by colour, calendar, word or guest domain, skips declined and all-day events, and closes each month into one statement per client.