View Single Post
  #5  
Old October 29th 07, 12:26 PM posted to microsoft.public.outlook.calendaring
Felix
external usenet poster
 
Posts: 3
Default How can I total on columns in a view?

I have been looking for exactly this functionality several months ago, but
haven't found a satisfactory answer either, so my reply is only to support
your point.

In my opinion MS should add totaling on a duration (or other numeric) as a
standard feature in Outlook view customization. Exporting to Excel is no
option, as you have to do a lot of manual processing each time you want to
make such a simple total.
--
Think, then move


"Jason R. Senior" wrote:

I have a simple view which has two columns. Subject and duration. I am
grouping on Subject. What I am trying to accomplish is this: I want total
hours worked on each Subject. My subjects are project numbers, such as
P-12345 and P-45678. I want the view to show P-12345 | 10 hours. Inside
that ten hours may be 5 different appointments, all with the Subject P-12345.
My view does properly group appointments by Subject, but surprisingly I see
no option in Outlook to total on a numeric field, such as duration. This
means I have to manually add up all the individual durations to get a total
duration.

Does anybody have any ideas short of exporting my calendar information into
Access?

Ads