Forum

Notifications
Clear all

Quarterly presentation

2 Posts
2 Users
0 Reactions
159 Views
(@zohar)
Posts: 5
Active Member
Topic starter
 

Hello,

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?

Thanks

 
Posted : 23/02/2021 9:26 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Zohar,

Please provide a sample Excel file as it's difficult to picture the problem.

Thanks,

Mynda

 
Posted : 23/02/2021 8:16 pm
Share: