Can I use make to get the average time of certain calendar events, and then creates a new event with that time duration

I want the average time inbed to be updated automatically for time tracking purposes.

Couple of ways to do this:

  • Add a new row in Google Sheets (include start time and end time) whenever a new calendar item is created. Once you collate the information inside a Google Sheet, you can calculate the duration of each meeting in a separate cell and then use sum/average hours in a separate column.

  • you can apply the above functionality inside the Make scenario but it will be more complex. You will probably have to use Math calculation functions and a set variable module to output the average time and store it somewhere.

1 Like