kiwistag
asked on
Calculating hours per week under specific categories in Outlook Calendar
To keep track of my work week & hours done - is it possible to either in Outlook (2007) now or even via some sort of plugin to have Outlook calculate & report as needed the total amount of hours for a specific category in the Outlook Calendar?
The 2 main categories I use are "Work" and "Remote".
It would be really useful to calculate this on demand for a day, week, month or even over a year if need be.
The 2 main categories I use are "Work" and "Remote".
It would be really useful to calculate this on demand for a day, week, month or even over a year if need be.
ASKER
I suppose some sort of Excel spreadsheet (CSV) but format would be the interesting part.
I know what I want but not how I want it, I suppose it all depends on what is available.
I know what I want but not how I want it, I suppose it all depends on what is available.
I assume it needs to report on tasks, right?
ASKER
Categories may be easiest.
I talked to a Microsoft Solution Specialist & he recommended getting an API designed for it - am yet to check with him & see if someone has already built somethign suitable.
I talked to a Microsoft Solution Specialist & he recommended getting an API designed for it - am yet to check with him & see if someone has already built somethign suitable.
I don't know what they mean by "API designed". Outlook already has an API. This just requires a script. It's simple enough to do this, I just need to know what sort of output you're looking for. Do you just want the total, do you want to list each item, etc. If the former, then will a pop-up dialog-box reporting the total be sufficient?
ASKER
Sorry, late nites & wrong terminology.
Basically all I'm after is the total for a week (or month) linked to a category. Lists of each item aren't really necessary as most info is within each time period/meeting/appointment and the title just vaguely references the category anyway.
Thanks.
Basically all I'm after is the total for a week (or month) linked to a category. Lists of each item aren't really necessary as most info is within each time period/meeting/appointment
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works a charm - thanks :)
ASKER
Excellent result :)
Thanks again :)
Thanks again :)
You're welcome. Glad I could help.
I am hoping someone might be able to tell me why this macro was working perfectly on Friday and now, Saturday, it isn't working? I am getting a runtime error 13: type mismatch.
Can someone help me? I am a novice with Visual Basic.
Can someone help me? I am a novice with Visual Basic.
Nevermind I figured it out. I was using the wrong date format. Thanks.
What sort of output are you looking for?