Google Calendar Sum Hours
Lets see how you can easily track the total amount of hours that your events or tasks in google Calendar would take. We will accomplish this by using Timetackle.
* No Credit Card Required
How to track the total time contained in your Google Calendar
Step 1
Sign in with your Google account
- If you haven’t already, login to TimeTackle and go to the report section
- Choose the Google Calendar/s you wish to export
- Select the data fields and specify the range (start date and end date)
- Click on the file type you want the Google Calendar to be exported into
Step 2
Sum calendar hours
- Open your downloaded file in .xlsx or spreadsheets
- Select an empty cell and type in the formula " =SUM( "
- Select all the cells you want to sum and press enter
Step 3(optional)
Sum the time of certain events only
If you want to only track the time of certain events in your google calendar/s you can do so by using the “Search Filter” feature.
- Go to the report section
- Choose the filters to filter out the data you want
- Now, click on the download button to download the file to your computer in your chosen format.
- Follow Step 2
