Sum up all 'durations' in a Find result display

[Guest]

I'm wanting to add my work annual leave to Outlook and auto sum, so I know
how much holiday I've up so far. I'm currently adding it in as an Appointment
called A/L, then I search for text A/L. My results search has the following
fields:
*Subject (A/L)
*Start & End (date and time) (usually start at 8:30 and ends to achieve the
right number of hours
*Duration (in hours)
I'm after a way to sum up the all 'durations' in this Find result.
Or just an easier way to record, search for a sum up annual leave in
Outlook...
Any ideas?
I'm using Outlook 2000 and 2003

 

[Sue Mosher [MVP-Outlook]]

Copy and paste the display to Excel and do the math there.

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

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

 

[Guest]

So no function for this at all in Outlook? Not even creating your own
rules/macros/functions? Hard to believe it's not there....

 

[Sue Mosher [MVP-Outlook]]

You would need to write your own VBA macro to iterate all the items in the folder that meet your search criteria and generate a running total. VBA basics start at http://www.outlookcode.com/d/vbabasics.htm. If you get stuck, 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

 

[Guest]

Excellent. Many thanks.

You would need to write your own VBA macro to iterate all the items in the folder that meet your search criteria and generate a running total. VBA basics start at http://www.outlookcode.com/d/vbabasics.htm. If you get stuck, 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