Zohar Shemesh
Active Member
Members
Forum Posts: 5
Member Since:
February 17, 2021
February 17, 2021
Offline
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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1943
SunnyKow: 1432
Anders Sehlstedt: 937
Purfleet: 415
Hans Hallebeek: 363
Frans Visser: 349
David_Ng: 313
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Ponnivalavan Padmanabhan
Solangel Clark
MUHAMMAD FAISAL
Waqas G
Pala Taurai
Jacob Storoz
Riitta Pennanen
Jake Whaley
Debby Hamic
erl eng
Forum Stats:
Groups: 3
Forums: 25
Topics: 7118
Posts: 31218
Member Stats:
Guest Posters: 50
Members: 34585
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —