Forum

Notifications
Clear all

Spliting working hours in quarters

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

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

 
Posted : 20/02/2021 9:38 am
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

Hello,

Can you share a sample file so we can see your data structure?

Br,
Anders

 
Posted : 20/02/2021 5:29 pm
Share: