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

calendar outlook categories time-management
ateich picture ateich · Aug 5, 2014 · Viewed 15.4k times · Source

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

Answer

Irina Pupaza picture Irina Pupaza · Jul 23, 2015

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

Related questions

.NET: Get all Outlook calendar items

How can I get all items from a specific calendar (for a specific date). Lets say for instance that I have a calendar with a recurring item every Monday evening. When I request all items like this: CalendarItems = CalendarFolder.Items; …

Read More
How to create a .ICS file with multiple VEVENTs to be imported into an existing Outlook Calendar

I have a need to allow for a user to download an event that has multiple meeting dates. To do this I have created a memorystream to be downloaded which produces a .ics file. For example: BEGIN:VCALENDAR PRODID:-//…

Read More
Add ics file to outlook 2011 (Mac) as new calendar

I've created an .ics file with multiple events that I would like to add to Outlook as a new calendar (so I can easily remove it). If I double click the .ics file, the events get added to my current …

Read More