• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    roll up sum of time spent from children rows to parents

    Shrivallabha, This is brilliant and exactly what I was looking for. Thank you, Ronen
  2. R

    roll up sum of time spent from children rows to parents

    Hi Narayan, Proximity is important, more accurately the ordering of the records is important and indicate which rowID is a child and who is the parent. Under thevassumption that ordering is important your second statement is not valid, since #6 should relate to his immediate parent in order...
  3. R

    roll up sum of time spent from children rows to parents

    Sure! The table represents a 3 level hierarchy, e.g. row #3 & #4 are immediate children of #2 , hence the calculated time spent for #2 is the sum of time spent on #3 and #4, which is 2 (1+1). #2 is a child of #1 and also #5 is a child of #1, hence the calculated time spent for row 1 is 3...
  4. R

    roll up sum of time spent from children rows to parents

    Hello all, Having the following excel table, I would like to roll up the sum of TimeSpent from level 3 rows to their parents in level 2 and 1, the column CalcTimeSpent show the expected results. VBA code is preferable. Thanks in advanced, Ronen RowID Level TimeSpent CalcTimeSpent 1 1 -...
Back
Top