Counting hours in calendar by category

%3CLINGO-SUB%20id%3D%22lingo-sub-364694%22%20slang%3D%22en-US%22%3ECounting%20hours%20in%20calendar%20by%20category%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364694%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20count%20time%20spent%20in%20a%20date%20range%20by%20category.%20%26nbsp%3BI%20can%20do%20an%20advanced%20search%20and%20get%20a%20list%20but%20I%20need%20to%20total%20up%20the%20hours.%20%26nbsp%3BWe%20need%20to%20do%20it%20every%20month%20across%20dozens%20of%20categories%20and%20date%20ranges%20so%20I%20am%20looking%20for%20easy%20execution%20or%20automation.%20Does%20anyone%20have%20any%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-364694%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOutlook%20for%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-375851%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20hours%20in%20calendar%20by%20category%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-375851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F102430%22%20target%3D%22_blank%22%3E%40David%20LaSalle%3C%2FA%3E%26nbsp%3B%20fantastic%2C%20thankyou.%26nbsp%3B%20I'll%20have%20a%20look%20at%20both%20of%20these%20and%20post%20how%20Igo.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-366825%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20hours%20in%20calendar%20by%20category%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-366825%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThese%20are%20not%20endorsements%20or%20recommendations%2C%20just%20sharing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.vboffice.net%2Fen%2Fproducts%2Folreporter%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.vboffice.net%2Fen%2Fproducts%2Folreporter%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.howto-outlook.com%2Fhowto%2Ftimespent.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.howto-outlook.com%2Fhowto%2Ftimespent.htm%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2188059%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20hours%20in%20calendar%20by%20category%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2188059%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20did%20it%20go%3F%20I%20am%20looking%20for%20a%20solution%20like%20this%20right%20now.%20What%20has%20worked%20well%2C%20and%20what%20would%20you%20recommend%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need to count time spent in a date range by category.  I can do an advanced search and get a list but I need to total up the hours.  We need to do it every month across dozens of categories and date ranges so I am looking for easy execution or automation. Does anyone have any ideas?

 

4 Replies

@David LaSalle  fantastic, thankyou.  I'll have a look at both of these and post how Igo.

 

How did it go? I am looking for a solution like this right now. What has worked well, and what would you recommend? Thanks!

I gave VBOffice a try. It worked well if I did it for my own calendar, but not so well if I wanted to use it to grab information from another person's calendar I am a delegate for. It doesn't look like they have help channels available anymore unfortunately.