Solved: Excel time format [h]:mm:ss on power BI - Page 2

Baskar · ‎07-07-2016

Hi All,

Am facing problem in time. can u please anyone help me or guide me .

Prob :

My source is Excel.

Duration is filed name

Field value like "15:20:00" like "HH:MM:SS"

when am getting the excel in our power bi, the column is automatically converted as

but i need exact value like same as excel. "31-12-1899 03:20:0"

thanks & am waiting for your reply.

KHorseman · ‎07-07-2016

@Baskar in the query editor, convert the duration column to a decimal data type. Then after you load the query, go to the table editor and add a column:

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

Obviously you could also rename the original duration column something like OldDuration and name the new one Duration so you can still use a column with the same name.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

View solution in original post

Excel time format [h]:mm:ss on power BI

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly