“I need to convert each employee sub-calendar to a spreadsheet which sums all the working hours of each employee, so we can send the total worked hours to the finance department.”
How to export reports from your calendar
Once you have the options set as you want, click the green Export button to download the CSV file. You can then import the data into Excel; make sure to check “My data has headers.” It will be a delimited file, with the fields delimited by commas.
To generate the report, you could sort by “Calendar Name,” using the start time and end time of each event to calculate the hours for each employee’s sub-calendar. You may need to insert a column for the calculated results.