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