Forum Discussion
Text to Time conversion
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
1 Reply
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.
