Pulling conference room usage data from Outlook Calendar to input into Excel project

Shayll

New Member
Joined
Mar 27, 2020
Messages
8
Office Version
  1. 365
Platform
  1. Windows
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.

Capture.PNG
 
Could you send me some sample data please.
Use dropbox or similar for file transfer and post the link back here.


If your file contains sensitive company data, could you please "doctor" the file please.
Paul.
 
Upvote 0

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Here are two links, one to the csv file I pulled from Outlook with start times/dates and end times/dates and also the actual Excel project (no sensitive data)

csv

Project
 
Upvote 0
Hi,
Try this, I have added the detail in stages so you can expand it to the other rooms.


Paul.
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top