Text to Time conversion

[harshjoshiD]

Hello,

I am new to PowerBI. I have a column in PowerQuery named "Media Elapsed Time Text" which contains the values of time elapsed in Text format d.hh:mm (Days.Hours:Minutes) as shown below:

I need to convert it into the format of hh:mm:ss (Hours:Minutes:Seconds). As seconds are not mentioned in the initial data seconds can be "00". But I need to transform the mentioned column from Days to Hours fromat. So for e.g '1d.13:42' will become '37:42' (1d = 24 hours, adding them to 13:42 becomes 37:42).

Is there any way I can perform it in PowerQuery..? Any help on this will be appreciated.

Thank you

[HoangHugo]

Hi ,time format should be 0 > 24. it is impossible to your expectation. I think you only show your expected result by text format. Use functions like LEFT, RIGHT, MID to take number of days, then convert ti to number and multiply 24, add number of hour (already convert to number). End, you combine with number of minutes under  text type as you want.