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

Question

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].

Solution

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