Spliting working hours in quarters|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello,

I am managing a teamwork plan for several projects.

I need to quarterly present each member's working hours for each project.

I have managed to properly create a pivot table that does it.

The only issue I have is that the pivot table does not calculate the quarters properly, for example:

Task 1: start @ 13.03.2021, end @ 15.04.2021, working hours 180.

The pivot table will sum the hours for both Q1 and Q2 instead of dividing the Task1 hours until the

end of 31.03.20201 for Q1 and from 01.04.2021 hours for Q2

Is there an easy or straightforward way to do that?

Thanks