ateich
ateich

Reputation: 203

Count / sum-up weekly work time by calendar category (MS Outlook)

Is there a way to sum up the time of all meetings for each category (e.g. red) for a specific period of time (e.g. the last week) in Outlook? Thereby, I want to analyze how a spend my time during the week [I assign every single time slot to exactly one category].

Upvotes: 3

Views: 19083

Answers (2)

Joel.O
Joel.O

Reputation: 2054

There's another option :

To use an application that can gather your Outlook data and provide reports, for instance :

  • TrackingTime : directly connects to Outlook and you can choose which calendar(s) to use, provides reports by calendar and people.
  • Timecamp : You can import ics files, that'll give you many report options too
  • Probably many more, that I haven't tested.

Upvotes: 0

Irina Pupaza
Irina Pupaza

Reputation: 61

Here are two ways of achieving it:

http://www.howto-outlook.com/howto/timespent.htm

  1. by using a VBA macro
  2. by exporting to Excel and making a report in Excel

Upvotes: 4

Related Questions