How to Automatically Calculate the Time Used in Certain Google Calendars
With Google Calendars, you can create multiple calendars to keep track of activities, events and special dates. However, while the Google service shows the duration of calendar events, it doesn't show the total amount of time dedicated to these activities. Using GTimeReport, you can see the time spent on each individual Google calendar. This third-party application is free and requires only a Google account to access.
1 Open the GTimeReport website
Open the GTimeReport website (link in resources). Click "Login to your Google Account" located in the upper right-hand corner of the page.
2 Sign in with your Google username and password
Sign in with your Google username and password. Click "Grant Access" to allow the site to access your Google calendar information.
3 Check off the calendars
Check off the calendars you wish to include in your time report under "Your Calendars." Click "Select All" to choose all the listings.
4 Choose the time period for the report
Choose the time period for the report by entering the year, month and date in the "From" and "To" sections located under Period.
5 Choose your location and language and under Locale
Choose your location and language under Locale. Check the boxes under Output to further customize your report. For example, you may choose to filter your all-day events, or show a summary table in the report.
6 Choose one
Choose one of the reporting options at the bottom to create your report. You may choose to simply create a report, export a report to Excel or move the report to a new window.