Convert Duration From 0.00:00:00(DD.HH:MM:SS) to 00:00:00(HH:MM:SS)

[nmazibuko004]

Hi 

I would like to find out how can I convert Duration to hh:mm:ss. I initially had duration as text format date/time and managed to split the column and reflect Duration as Data Type 'Duration' successfully in Edit Queries. The issue is now it is reflecting as days 0.00:00:00(DD.HH:MM:SS).

How can change the format so that it only displays as HH:MM:SS?

[v-frfei-msft]

Hi @nmazibuko004,

Here we can add a calculated column to get the format hh:mm:ss, please note that the data type of the column is text.

Duration1 = FORMAT(Table1[Duration],"hh:mm:ss")

Regards,

Frank

[v-frfei-msft]

Hi @nmazibuko004,

Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.

Regards,

Frank