I want to share an spreadsheet that may come handy when you have to track the time you have invested in your clients and present a report.
Download the book here: https://oficinavirtual1-my.sharepoint.com/personal/gerentegeneral_camconsultores_co/_layouts/15/guestaccess.aspx?guestaccesstoken=ZeTdttvvtRq9jN3K%2biYO%2f4AmhjuGm7r6g%2bOkP0jYn98%3d&docid=071ccf737fecd4aaf9fd2503f5bb2e5ea
To use it:
1- Go to the “Report” sheet and change the year of the report
2- Go to the “Base” sheet and press the “Get Outlook data” button (Have Outlook open so it process faster)
3- In the “Base” sheet change the header bellow the grape color to the main categories you want to extract from the list.
Note: The “Category” column in the Base sheet will only get the first non-blank main category found in the table.
VBA was adapted thanks to the code of Jimmy Pena: http://www.jpsoftwaretech.com/extract-calendar-data-from-outlook-into-excel/
Format function for hiding false values thanks to Susan: http://www.techrepublic.com/article/pro-tip-create-a-gantt-chart-in-excel/
Thanks by the way!
Disclaimer: This is a proof of concept so use it under your own responsibility