Guides

Practical answers for people who bill their time and live in Google Calendar. Each guide starts with what you can do for free.

• How to turn Google Calendar into a timesheet

  By hand, with a short script in Google Sheets, or automatically, with the pitfalls that make totals wrong.

• How to count hours in Google Calendar by client

  Colours, calendars, keywords and guest domains: four ways to tag time, and how to add it up.

• Export Google Calendar to Google Sheets automatically

  The built-in export, a script with a timer, and add-ons, compared honestly.

• Bill clients from Google Calendar: rates, rounding and minimums

  Hourly rates per client, rounding rules, minimum charges, retainers and month-end statements.

• Google Calendar time tracking: billable hours without a timer

  Plan the work as events, correct them when they end, tag each client and count. Five mistakes that make totals wrong.

• Google Sheets timesheet template for freelancers, with formulas

  The columns and the exact formulas: duration, rounding up to 15 minutes, minimums, amounts and monthly totals per client.