Total time for selected appointments?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to easily add up all the durations of all the
appointments that meet a specific criteria such as all the appointments in a
particular category. Is this possible?

If it requires a macro could anyone give me a head start on writing it? I am
a computer science student and have been using Outlook since it first came
out but I am not familiar with what macro commands are available in Outlook
and how to make the macro operate on only the appointments I want.
 
Quick and dirty method:

1. Use a table view to display all the data fields that you want to export to Excel, filtered to show just one category if you like.
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
 
Back
Top