Calculating Sum of Hours from Child Rows
I am trying to sum up the "Total Hours Used" from Child rows (white highlighted) into the "Total Hours Used" parent row (black highlighted). I cannot use StartTime and EndTime here, because the time slots are not necessarily continuous. Appreciate any inputs on this.
Child Rows - "Total Hours Used" Calculated as 2 hours, 4 hours and 3 hours respectively.
Parent Row - Expected "Total Hours Used" = 2:00+4:00+3:00=9:00.
I checked a bunch of threads, but I wasn't able to find a solution for this one. Any inputs would be highly appreciated.