get assignment rows and split hour duration across cells