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