Duration in Power Bi

[Shivrajvk]

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 date/time format, something like 12/31/1899 HH:MM: SS. 

How do I get my data in the HH:MM:SS format in Power Bi? I need to calculate the average of that column. 

Please help.

Note: I've tried changing the column in excel to General format and then changing the format to duration in Power BI, that gives me the format as DD:HH:MM:SS. 

@Greg_Deckler can you please help me?

[Shivrajvk]

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. 

[AbbasG]

@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...

Hope it helps!

[Shivrajvk]

@AbbasG The Format function works by the output is in a text format. I want to calculate the average of the entire duration column. Is there any way to do that?

[AbbasG]

@Shivrajvk please share some sample data (after removing all the sensitive information), with desired out come.