Duration is not calculating correctly when using hours duration

Gloria Sirosky1

Some parent rows have 0 days as the summationof the assocaited child rows and and some have arbitrary number of days.  Since it is in a rollup value from child rows I cannot change.  Any suggestions? 

Bob Andrews

Parent rows will automatically show the full duration of all the child rows - this is NOT a SUM of child row durations. The parent row duration is calculated by the time between the parent row start and end dates, which are rolled up from child rows. 

Alicia Barco

Is there a way to calculate the duration of child durations only (exact level of effort)?

Bob Andrews

Parent rows will automatically show the full duration of a set of tasks. If you would like to SUM child row durations, use this formula (not in your Duration column):

 

=SUM(CHILDREN(Cell1))

 

Replace the "Cell1" reference with the parent row Duration column cell.