This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I use "categories" in outlook office 365 to differentiate my meeting types. I would like a report that tells me how many hours I have spent in each category. Is there a report or process that can determine that for me?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
>>
the excel method and unfortunately, this would not pull over "reoccurring" meetings, which made the tool far too inaccurate. Had I not had a significant amount of reoccurring meetings, the excel version would have been easy and functional.
<<
For recurring events, you need to export to a CSV, not copy and paste - this breaks all recurring events into individual items. You can use a filter to limit the export to a date period or filter in Excel to hide older or future events.
Hello Shawna
There are 3rd party report apps or you can use VBA or manually to get the information.
To do it manually - create a list view with the fields you need - subject, start, end, duration, category etc - select all, copy and paste into Excel and add up the durations by category.
VBA would basically do the same but automate it more.
-- Diane
Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.
To add to Diane's reply; An example of how to do this via a macro can be found here; 3 Methods to report time spent on Meetings, Tasks and Journal items - HowTo-Outlook
Thank-you for the additional details. I did not try a 3rd vendor as my organization does not normally let me just download outside apps to my work computer. I did attempt the excel method and unfortunately, this would not pull over "reoccurring" meetings, which made the tool far too inaccurate. Had I not had a significant amount of reoccurring meetings, the excel version would have been easy and functional.
