In this article we will be teaching you how you can easily track the total amount of time or days that your events or tasks in google Calendar would take. We will accomplish this by using gcal2excel.com.

What is a Google Calendar

Here’s the deal- want to keep track of your life; you want to manage your events, special dates and plan your day to day activities but don’t want to burden yourself with the of use physical calendars and notes.

You want a simple and robust planning software where you can access and plan for your events and appointments anywhere and share them with your friends and colleagues with the touch of a button. What you need is a Google Calendar.

Google Calendar is a time-management web application and mobile app created by Google. It allows you to create planners called Google Calendars easily and intuitively. In a google calendar you can input your different events and plans and have the option to get a notification about them. Anyone who would like to plan their life electronically should look at Google Calendar.

If you have a google account you can easily use Google Calendar to manage your life. Simply access the application via the web at this site or download it at Google Play or the App Store.

What is time tracking?

Time tracking is when you measure the amount of time it takes to complete task/s or events in from your Google Calendar/s. This is particularly helpful if you need to budget your time and need to know exactly how much time you would need for your tasks and events.

Time tracking using Gcal2Excel

Gcal2Excel is a Google Calendar exporting service. Not only can you export your Google Calendars in various formats, you also have the option of exporting it together with the total amount of time that the tasks and events in a calendar have.

Coupled with the ability to filter events to export in Gcal2Excel, you can further customize which tasks and events you specifically want to be tallied in tracking your time.

How to track the total time in contained in your Google Calendar

You’ve already created a Google Calendar and you want to track the total amount of time that the tasks and events contained in the calendar is. One website that does the work for you is Gcal2Excel. There is No installation required, no hassle!

In order to track the total amount of time you will need to export the Google Calendar/s.

Here’s what you’ll see when you enter the site:

Picture1

Gcal2Excel can export your Google Calendar or Calendars (You can export more than one at a time) into various formats: XLSX, XLS (Microsoft Excel); SPREADSHEET, HTML, and PDF.  Simply follow these steps

  • If you haven’t already, login using your Google account
  • Choose the Google Calendar/s you wish to export

Screen Shot 2016-06-07 at 5.49.37 PM

  • Specify the range (start date and end date)

Picture3

  • Click on the file type you want he Google Calendar to be exported in.

Picture4

Enabling Time Tracking

Picture1

In the exporter Tab you can set these additional options before you export your Google calendar/s. Click on the additional  drop down menu and you’ll see the following fields:

Picture5

Checking “Sum all” will calculate the total duration of all events present in the Google Calendar to be exported.

Checking “Day Total” will calculate the total amount of days present in the Google Calendar to be exported.

 

 

 

 

 

 

 

 

Track 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 of Gcal2Excel.  The Search Filter can be found on “Filters”.

Typing words in the Search Filter will tell Gcal2Excel to export only events with those words present in the title of the event. This paired with the “Sum Total” and  “Day Total” options will only sum up the total time of the events with the keywords present in them.

Picture2

Here, only events with the keyword “day” will be exported and have their time tracked.

After a short while of processing a pop up should show appear prompting you to download your exported Google Calendar/s. Congratulations! You’ve just exported your google calendar.

Picture3

What more you can do with the Google Calendar Export feature of Gcal2Exel.

Gcal2Exel is a very powerful Google Calendar Export tool.

When exporting your Google Calendar, you have the ability to access the various options in exporting your google calendar which changes its format and fields.

You can save your settings in a template so you can use it in a future Google Calendar Export.

Gcal2Exel has a feature called recurring exports where you can schedule Google Calendar exports that automatically gets sent unto your Gmail inbox periodically.

You can click here for more things you can do.