How Much Time Do you Spend in Meetings?

In this post, I’ll analyze my Google Calendar events to see exactly how much time I spend in meetings each week.

Does it seem like moving to be remote has increased the amount of time we spend in meetings? To find out, I’ll use the Google Calendar API to easily extract all my calendar events and analyze the data.

To start, you will have to follow the directions here to Enable the Google Calendar API. Once you have authenticated your account, we are ready to get started. Here are the packages we need:

Python

Next, we can grab our calendar events. I’ve slightly modified the code from Step 3 of the Getting Started page. There are two things you may want to change:

  1. Line 26 is where you choose how far back you want to go to get your calendar invites.
  2. Line 30 determines how many results to return. I set it at 1,000 to get everything.
Python

Now all the events are stored as JSON in a variable called events. To take a look at one event, run events[0].

There are a lot of data points for each event. In the next step, I’ll put the data into a DataFrame and isolate the fields I need for this analysis.

Python

We then have to break up the dictionary in the columns:

Python

Next, we will convert the date columns:

Python

Now we have the start and end dates formatted and can move on to calculating the duration of each event. I’m essentially subtracting the dates, returning the seconds, then converting those into minutes, and then finally into hours:

Python

At this point, our DataFrame should look something like this:

Note that I am excluding the summary column from this screenshot

Now I am going to apply a filter to remove some events that are not meetings. Sometimes on my calendar, I’ll block off large chunks of time to prevent a meeting from being scheduled, for out of offices, and travel itineraries. In my case, it’s usually anything longer than an hour.

Python

The last data transformation is going to be to aggregate the data by week and sum the duration.

Python

Finally, we are ready to plot the data to see what the data looks like. My x-axis is going to be the week. My y-axis is going to be total hours in meetings divided by 40 and will represent the percentage of time spent in meetings. I am using Plotly for my visualizations.

Python
Jul 2020Aug 2020Sep 2020Oct 2020Nov 2020Dec 20200%10%20%30%40%50%
Time spent in Meetings each week

After all that it looks like it’s anywhere between 30-40% of my time is in meetings. Is that a lot? I’ll let you (or my manager) determine that one. Thanks for reading!


Posted

in

by

Tags: