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

IThanks, Diane. I already had done the custom field before, but not though
about the copy instead of the export.
However, I still have to add the sum formula for each category, each time I
do a copy to Excel again, correct? This is what Iam trying to avoid or
automate.

--
Think, then move


"Diane Poremsky [MVP]" wrote:

To add it in excel, create a custom view with a custom field that uses a
formula that removes the text or converts everything to minutes so you can
easily calculate it. (try using Trim([Duration]) - it works for here in a
quickie test). Then copy and paste from Outlook into Excel (its easier than
using export) - the duration fields will total easily.

If you have no idea how to do this, there is a step by step (using a
different formula) at
http://www.outlook-tips.net/beginner/remindertime.htm - use the formula
above instead.

also, I believe there are sample forms and formulas on outlookcode.com that
total duration.



--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips:
http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"Felix" wrote in message
...
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