Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
Hi @nmazibuko004,
Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.
Regards,
Frank
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |