Thread
:
How can I total on columns in a view?
View Single Post
#
7
October 29th 07, 03:03 PM posted to microsoft.public.outlook.calendaring
Felix
external usenet poster
Posts: 3
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?
Felix
View Public Profile
View message headers
Find all posts by Felix
Find all threads started by Felix
Ads