|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
April 28th 07, 11:10 AM
posted to microsoft.public.outlook.calendaring
|
|||
|
|||
Sum up all 'durations' in a Find result display
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 
|
|
#2
April 28th 07, 01:27 PM
posted to microsoft.public.outlook.calendaring
|
|||
|
|||
|
Sum up all 'durations' in a Find result display
Copy and paste the display to Excel and do the math there.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "itambrose" wrote in message ... 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
|
|
#3
April 28th 07, 03:16 PM
posted to microsoft.public.outlook.calendaring
|
|||
|
|||
|
Sum up all 'durations' in a Find result display
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]" wrote: Copy and paste the display to Excel and do the math there. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "itambrose" wrote in message ... 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
|
|
#4
April 28th 07, 03:21 PM
posted to microsoft.public.outlook.calendaring
|
|||
|
|||
|
Sum up all 'durations' in a Find result display
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/comm....program_v ba
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "itambrose" wrote in message ... 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]" wrote: Copy and paste the display to Excel and do the math there. "itambrose" wrote in message ... 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
|
|
#5
April 28th 07, 03:32 PM
posted to microsoft.public.outlook.calendaring
|
|||
|
|||
|
Sum up all 'durations' in a Find result display
Excellent. Many thanks.
"Sue Mosher [MVP-Outlook]" wrote: 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/comm....program_v ba -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "itambrose" wrote in message ... 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]" wrote: Copy and paste the display to Excel and do the math there. "itambrose" wrote in message ... 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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Find Command has Altered Calendar Display | Rick Altman | Outlook - General Queries | 0 | April 16th 07 04:23 PM |
| Dynamic result by recipient’s name | Pari | Outlook and VBA | 5 | February 12th 07 08:09 PM |
| Advanced Find Dialog Box - Manipulating the result | Irene | Outlook and VBA | 1 | December 26th 06 07:41 PM |
| Attchment is at a shortcut directory, result dir.lnk | שאלתיאל | Outlook Express | 15 | November 4th 06 03:05 PM |
| Outlook Script: How to get the result of an action | news.microsoft.com | Outlook and VBA | 4 | October 20th 06 12:18 PM |
Hybrid Mode
