Sum up all 'durations' in a Find result display

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

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
 
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
 
So no function for this at all in Outlook? Not even creating your own
rules/macros/functions? Hard to believe it's not there....
 
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
 
Excellent. Many thanks.

Sue Mosher said:
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
Click to expand...
 
Back
Top