Skip to main content
Working from scratch, following simplicity

cloud

Sponsored Links
Pubblicità

How to extract night and holiday hours from your Calendar with Apps Script

How to extract night and holiday hours from your Calendar with Apps Script

It's time to update my Google Apps Script that exports calendar events into a spreadsheet. I use it to comparison my worked hours with the month payroll, so putting all my shifts on Google Calendar I have in automatic a sheet with all the shifts data. I added how to extract night and holiday hours and count the worked days in a range of dates.

This is the third article on the topic and if you want to know more I suggest you to read the previous posts:

How to alternate colours when changes day

How to alternate colours when changes day

I am continuing the development of my script to auto-transfer Calendar entries into a spreadsheet. In this article I show you a convenient function to change the colour of the row when changes the day of the event, useful when for example you have more than one shifts and you want to improve the readability of the table.

5 steps to auto-transfer your Calendar entries into a spreadsheet

Instructions to generate a Google sheet from your Calendar entries

In the article and more accurately described in the video, I explain you how to export your calendar events into a spreadsheet using the Google Apps Script. Besides I show you the use of triggers to automate the update of the sheet when you change, add or remove an event.

An example on transfer entries from Calendar to Sheet through Google Apps Script

An example on transfer entries from Calendar to Sheet through Google Apps Script

I want to introduce you with a video, that show how fast and efficient is the use of Google Apps Script to automate the export of Google Calendar data into Google Sheet. Besides it is possible to instruct the code to make some calculation, change the style and do everything you want.

Subscribe to cloud

Nicola Rainiero

A civil geotechnical engineer with the ambition to facilitate own work with free software for a knowledge and collective sharing. Also, I deal with green energy and in particular shallow geothermal energy. I have always been involved in web design and 3D modelling.