How to combine 3 columns into a single column with HH:MM:SS format in Power Query editor

[imagautham]

Hello PBI Community,

I have 3 columns which refers to the hours, Minutes and Seconds which an employee spent.

I tried to combine the 3 columns into a single column with HH:MM:SS format. But Im not getting accurate answer.

I selected these 3 columns in power query editor and clicked Transform->Merge Columns-> used colon as delimiter.

I get the below output.

The new column 'Merged' doesnot come in proper HH:MM:SS format. This is because in hours spent I have value as 0.

It should come as 00 in merged column.

Any idea how to do this in power query editor or in DAX?

 

[imagautham]

Thanks @MahyarTF  for this

[MahyarTF · Accepted solution]

Hi,

you could use the below Dax code for creating the column :

 time(Sheet15[Hour], Sheet15[Minutes], Sheet15[Second])

Don't forget to change the dataType to Time and set the Format as you want.

Appreciate for your Kudos and Please mark it as solution if it helps you.