Google Calendar Time Tracking for Freelancers (No Timer Needed)
Track billable hours from Google Calendar without a timer: name and colour events by client, round to your increment, and total hours in Sheets.
You can track billable time in Google Calendar by treating each event as a time entry. Book every client session as an event, tag it to the client, then total the durations at the end of the week or month.
This works because most freelancers already live in their calendar. Calls, workshops and tutoring sessions are booked there anyway. You just need a few habits so the calendar doubles as a reliable time log.
Why your calendar already works as a time log
A timer app asks you to remember to press start and stop. Miss one and that time is gone. Your calendar records the session before it happens, so nothing slips.
Calendar events also carry useful detail:
- Start and end time, which gives you the duration.
- Attendees, which tell you who the client is.
- Title and colour, which you can use to group work by client or project.
The catch is that events need to reflect what actually happened. If a call runs 20 minutes over, update the event. That small habit is the whole system.
How to set up Google Calendar for time tracking
Follow these steps once. After that, tracking takes seconds per event.
- Pick one calendar for billable work. Use your main calendar or create a new one in Google Calendar under Other calendars > + > Create new calendar.
- Choose a naming pattern. Start every billable event with the client name, for example "Acme – strategy call" or "Lee – maths tutoring".
- Assign a colour per client. Open an event, click the colour dot and pick one. Keep it consistent, such as blue for Acme and green for Lee.
- Invite the client. Adding their work email means the attendee's domain (such as acme.com) identifies the client too.
- Fix the times afterwards. If a session ran long or short, drag the event edge to the real end time.
- Decline or delete what didn't happen. Cancelled sessions should not stay on the calendar looking billable.
Name, colour or attendee: which to use?
Use at least two. Then if you forget the colour, the title or the attendee still tells you who to bill.
| Method | Good for | Watch out for |
|---|---|---|
| Client name in title | Solo work with no attendees | Typos split one client into two |
| Event colour | Quick visual scanning | Only 11 colours in Google Calendar |
| Attendee email domain | Meetings with client staff | Personal Gmail addresses don't identify a company |
Turning events into billable hours by hand
At the end of the period, move your events into a spreadsheet. Here is the manual method in Google Sheets.
- Open Google Calendar in Week or Month view for the billing period.
- In a new Google Sheet, create columns: Date, Client, Start, End, Hours, Billed hours, Amount.
- Copy each billable event into a row. Type times as
9:00and9:50so Sheets reads them as times. - In Hours, enter
=(D2-C2)*24to get decimal hours. - In Billed hours, round to your increment. For 15 minutes, use
=CEILING(E2*60,15)/60. - In Amount, multiply by your rate:
=F2*120for A$120 an hour. - Use a pivot table or
=SUMIF(B:B,"Acme",G:G)to total each client.
For a fuller walkthrough with screenshots-style detail, see how to make a timesheet from Google Calendar.
A worked example
Say you bill Acme A$120 an hour in 15-minute increments, rounding up. This week you had three sessions.
| Day | Actual time | Rounded to 15 min | Amount |
|---|---|---|---|
| Monday | 50 min | 60 min | A$120 |
| Wednesday | 80 min | 90 min | A$180 |
| Friday | 25 min | 30 min | A$60 |
| Total | 155 min | 180 min | A$360 |
Without rounding, the same week is A$310. Your increment matters, so state it in your contract and apply it the same way every time.
Choosing a billing increment
Most freelancers bill in 6, 15 or 30-minute blocks. Here is how a 50-minute session at A$120 an hour comes out under each, rounding up.
| Increment | 50 minutes becomes | Amount |
|---|---|---|
| 6 minutes (0.1 h) | 54 min (0.9 h) | A$108 |
| 15 minutes | 60 min | A$120 |
| 30 minutes | 60 min | A$120 |
Lawyers and accountants often use 6 minutes. Coaches, tutors and consultants more often use 15 or 30. Pick one, tell clients, and stick with it.
What the calendar won't catch on its own
Calendar tracking is strongest for scheduled work. Some billable time never becomes a meeting.
- Prep and follow-up. Block 15 minutes after a call titled "Acme – notes".
- Focused project work. Book it as a block, such as "Acme – report draft, 2–4pm".
- Ad-hoc calls. Add an event afterwards with the real start and end times.
Treat the calendar as the record of truth. If the work isn't on it, it won't be billed.
Google Calendar vs timer apps
Timer apps are good tools, and many freelancers use them well. The question is which suits how you work.
| Tool | What it does well | Best for |
|---|---|---|
| Toggl Track | Polished timer, detailed reports, browser and phone apps | People doing lots of unscheduled desk work |
| Clockify | Generous free plan, team timesheets | Small teams on a budget |
| Harvest | Timers plus invoicing and expense tracking | Agencies wanting time and invoicing together |
| Google Sheets | Free, fully flexible | People happy to type entries by hand |
| Calendar-based (e.g. Clockless) | No timer; hours come from events you already booked | Freelancers whose work is mostly sessions and meetings |
If your day is mostly scheduled sessions, a timer means logging the same time twice. If your day is mostly unscheduled solo work, a timer app may suit you better.
The faster way: Clockless
The manual method works, but copying events into a sheet each month takes time. Clockless does that step for you, straight from Google Calendar, with no timer.
Here is how it maps to the setup above:
- Client matching. Meetings are matched to clients by attendee email domain, a word in the event title, or the event colour.
- Rounding. Each meeting is rounded to your billing increment, such as 6, 15 or 30 minutes.
- Clean data. All-day events and meetings you declined are skipped automatically.
- Timesheets. Clockless exports a CSV you can open in Google Sheets or Excel.
- Invoices. Pro creates PDF invoices in any currency, with GST, VAT or any tax name and rate. Invoice numbers increase automatically.
- No double billing. Once you invoice, those hours are marked as invoiced.
In the Chrome extension you can reassign or exclude a single event. In both versions you can change a client's matching rules at any time.
If you're registered for GST, a tax invoice must show certain details, including your ABN and the GST amount. The ATO's tax invoice page lists them. Check with the ATO or your accountant for anything beyond that.
Pricing and privacy
- Free: 2 clients, this week and this month, timesheet export.
- Pro: A$11 a month or A$99 a year. Unlimited clients, any period including past months, PDF tax invoices and invoiced-hours tracking. Cancel any time.
Clockless has read-only access to your calendar. Everything runs in your browser or your own Google account, and events are never copied to Clockless's servers. It's free on the Chrome Web Store.
Questions
Can Google Calendar track time on its own?
Not directly. It records when events start and end, but it doesn't total hours by client. You can total them in Google Sheets, as shown above, or use a tool like Clockless.
How do I track billable time without a timer?
Book every billable session as a calendar event, tag it to the client by name, colour or attendee, and correct the times afterwards. At the end of the period, total and round the durations.
What if a meeting runs over?
Drag the event's end time in Google Calendar to when it actually finished. Your timesheet then reflects the real duration.
Does Clockless work with Outlook or Apple Calendar?
No. Clockless works only with Google Calendar. It also has no phone app.
How should I round my hours?
Choose an increment, such as 6, 15 or 30 minutes, and state it in your agreement with clients. Apply it consistently to every session. For a step-by-step sheet setup, see making a timesheet from Google Calendar.