Forum Discussion
Duration in Power Bi
I have a column named duration in which data is in the format hh:mm: ss The data is displayed correctly in Excel but when I import the excel file in Power Bi, the format of the column changes to a ...
Hi AbbasG , I have the data as below in in Excel,
And what I have in Power Bi is like
I want the data in the format HH:MM:SS.
Shivrajvk I think you can use the FORMAT function here.
Additionally, you can also refer the following solution - https://community.powerbi.com/t5/Desktop/Extracting-only-minutes-and-seconds-from-a-date/m-p/2201488#M805419
Hope it helps!
