trying to convert to [h]:mm

[manutd]

in the query editor, i converted the duration column to a decimal data type (i applied these changes) and went to the table editor and i was about to add a column:

New Duration = FORMAT(TableName[Duration], "HH:mm:ss")

but before i added this (the new column) i noticed that the duration (decimal format column) was filled with values of 0 (but in the query editor it didn't have values of zero)? 

[v-caliao-msft]

Hi @manutd,

Which data type do you use for your original duration column? Could you please provide us some sample data, so that we can make further analysis.

Regards,

Charlie Liao

[manutd]

[manutd]

[manutd]

In excel the column is h:mm, but in power bi it auto changes to decimal, but when i covert from decimal to h:mm (in bi) the value shows as zero in the table editor.