Hi all,

I'm creating a time management spreadsheet to track where I spend my time. The spreadsheet has 5 columns and unlimited rows. The first 2 columns are Start time and End time and the following 3 columns are "Projects, Subcategory 1 and Subcategory 2". The idea is to show how much time I'm spending on each project and subcategory within the project.

Ideally I'd like to output a pie chart with the overall results for each Project and then a pie chart for each subcategory within a project. My hours vary and I'd like the pie chart to show not only percentage of time that I'm working on each project / subcategory but also the total hours spent on each for each day, week and month.

I have set the start time for the next task to auto-populate with the end time of the current task.

Thanks for your help!

D
Excel 2003