Time report from Outlook 2013 calendar (with categories) in Excel 2013

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.

Credits:
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

Anuncios

Acerca de ricardodiazjimenez

I'm a person of big ambitions, but takes care of small details. As an entrepreneur I have learned to value people that surrounds me and invest in their wealth. Living in a big chaotic city has been an inspiration for ideas to make working from home a viable option. From some years, until now, I have discovered that sharing my knowledge is a way to feel good and at the same time, receive more. I have invested in a headhunting company specialized in information technology, an elearning content production company and an outsourcing administrative services company.
Esta entrada fue publicada en Sin categoría y etiquetada , , , , . Guarda el enlace permanente.

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s