Calrows

How to track billable hours from Google Calendar™

Updated 4 October 2026

If you already block client work in Google Calendar, your billable hours are already recorded. You only need them as numbers. Here is how to turn a month of calendar time into hours and amounts per client.

Name events so they add up

Start event titles with the client: "Acme: design review", "Acme: call", "Birch: workshop". That one habit lets you filter and total by client later.

Build the billable hours sheet

  1. Install Calrows from the Google Workspace Marketplace (free), open your sheet, then go to Extensions › Calrows › Open sidebar.
  2. Pick the calendar you log work in (calendars shared with you are listed too).
  3. In Timesheet, choose the month, type the client name (for example Acme) in Only titles containing, and enter your hourly rate.
  4. Click Build timesheet.

You get one row per event (date, title, start, end, hours, rate, amount), a total, and a summary by event title. All-day events are left out, since a holiday isn't billable time. Hours are rounded to two decimals, so 45 minutes is 0.75.

For agencies and teams

Run the timesheet once per person's calendar, or on a shared team calendar, and you can see where the team's hours go per client, which is how agencies spot under-billed work. Team plans cover everyone with one payment.

See also: how to make a timesheet from Google Calendar and exporting Google Calendar to Google Sheets.

The free plan builds timesheets of up to 50 events at a time. Pro has no limit and is a one-time payment with no auto-renewal.

Frequently asked questions

Do I need a separate time tracker?

Not if your work is already in Google Calendar. Calrows reads the events you already have.

Can I bill different clients at different rates?

Yes. Build one timesheet per client with its own rate, using the client name filter.

Can I export it to Excel for my invoice?

Yes. The timesheet is a normal Google Sheet: File › Download › Microsoft Excel (.xlsx).

Install Calrows, free