Can I get total time busy for a conference room in Outlook 2003?

[Guest]

I have a user who would like to know the total percentage of time any
specific conference room is booked. We run Outlook on an Exchange Server and
our conference rooms are scheduled through Outlook meeting requests or
appointments as resources. Is there a way to pull this information?

 

[Sue Mosher [MVP-Outlook]]

Quick and dirty method:

1. Use a table view to display all the data fields that you want to export to Excel.
2. Choose Edit | Select All.
3. Choose Edit | Copy.
4. Paste to Excel.

Use Excel to calculate the difference between start and end date/times and add up the total.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Sorry.... my question was not very clear. I need to be able to do this
programmatically. I am writing a windows app using vb .net. One of my
customer's 'like to have' requirements is to be able to see the percentage
use for their conference rooms from within the application.

 

[Sue Mosher [MVP-Outlook]]

Then you'll need to iterate the items in the folder, read the value of the Duration property for each one, and total the results. Use the Namespace.GetSharedDefaultFolder to return each resource mailbox's Calendar folder.

FYI, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers