I've been working on a project for my boss that details room usage at our facility. I have been referencing our conference room Outlook calendar to manually input the number of meetings, start time, end time, and name of the meetings per week. We are working on this project to show upper management how busy/packed our rooms can get on any given week. I was wondering if it was possible to pull all of the data I need from the Outlook calendar and then input that data into Excel without having to do it manually? Here is an email from my boss explaining what she would like done:
"I wish there was an easier way to do this, like if we could export the calendar into excel and make a formula to pull occupied times and compare it to max possible occupancy? Do you think that’s possible? I feel like if we can show facilities that for any given week a room can be occupied for an 8-9 hour work day / 40-45 hours per week and each week it’s occupied 50-80% of that time or whatever then it may save time and get a more quantifiable number"
I'm not great at Excel so I don't know if this is something that is possible but I figured I would ask here and see if anyone has any suggestions! I've attached a picture of the project just for reference.
"I wish there was an easier way to do this, like if we could export the calendar into excel and make a formula to pull occupied times and compare it to max possible occupancy? Do you think that’s possible? I feel like if we can show facilities that for any given week a room can be occupied for an 8-9 hour work day / 40-45 hours per week and each week it’s occupied 50-80% of that time or whatever then it may save time and get a more quantifiable number"
I'm not great at Excel so I don't know if this is something that is possible but I figured I would ask here and see if anyone has any suggestions! I've attached a picture of the project just for reference.