Hi All,
I have data as below in excel. The data is coming in duration format i.e 2.05 is 2hrs and 5 min, 117.15 is 117 hrs and 15 min.
1.00
3.00
2.05
0.15
0.30
3.45
1.05
117.15
0.50

On this data, I have created a pivot to show the sum, but the result is shown as 128.65 instead of 129.45.
Can someone please let me know how to solve this?

Note: The data is dynamic in the report.

Thanks