Pivot data aggregation on duration formate

When I use data in duration formate (“0:08:06”) and apply sum, min, max it display the data back in number formate.

These operations are intended for number values, so the only way here is to apply a custom operation for your data.