February 17, 2021
I am using excel to manage my small team projects.
Each employee has his own tasks (start date, end date, etc...)
I am managing each project for a percentage part of my working day supporting each project (let's say 10% for each project).
I am using a pivot table to present the project's total working hours in quarters.
Now, the issue:
Each project includes a single row that represents my partial (10%) support for a period of several quarters (start date, end date).
When I summarize the working hours (quarterly), using the pivot table, it adds me only within the start quarter (since it has a single row for myself) and not split it to the next quarters (it does not use the quarters, which can extract from both start and end dates).
Is there an easy way to resolve this issue? Must I add a new table to summarize partly working hours?