Calculate hours from Google Calendar

Export your calendar as an .ics file, drop it here and get total hours per event name, client, week, month or day. Recurring events are expanded, and nothing leaves your browser.

Everything runs in your browser. Your text and files stay on your device and are never uploaded.

How to use it

  1. In Google Calendar open Settings, choose Import & export, then Export. Unzip the download to get one .ics file per calendar.
  2. Choose the .ics file here, or paste its text. Press Load example to see how the result looks first.
  3. Pick how to group the hours. Client reads the text before the first colon or dash, so a title like Acme: weekly sync counts toward Acme.
  4. Set a date range, and list words to skip such as lunch or focus time if those events should not count.
  5. Add an hourly rate if you want a value for each row, then download the CSV or copy the table into Google Sheets.

Questions

How do I export Google Calendar to an .ics file?

Open Google Calendar on a computer, click the gear icon, choose Settings, then Import & export, then Export. Google downloads a zip with one .ics file for each calendar you own. Unzip it and choose the file for the calendar you want to total.

Does it count recurring events?

Yes. Weekly, daily, monthly and yearly repeats are expanded into individual events, with exceptions, deleted occurrences and edited single occurrences handled. A repeat with no end date is counted for one year after it starts, or up to the last dated event in the file.

Which time zone are weeks and days counted in?

The zone in the time zone box, which starts as your device's zone. Events keep their own zone when the file names one, so a 9am Chicago meeting stays 9am in Chicago across daylight saving changes. Change the box if your week should follow another zone.

What about overlapping events and all-day events?

Each event is counted on its own, so two meetings that overlap by 30 minutes both count in full. All-day events are skipped by default because they have no real length. Tick the option to count them at 24 hours for each day they cover.

Can I get hours per client?

Group by Client. The tool takes the text before the first colon, dash, pipe or square bracket in the title, so Acme: design review, Acme - design review and [Acme] design review all land under Acme. Titles with no prefix are listed together so you can rename them.

Is my calendar uploaded anywhere?

No. The file is read inside your browser and the totals are worked out on your device. Closing the tab discards it.

More free tools

All free tools