topic Re: How to convert the text value "50:23:06" to seconds in Power Query, in DAX Commands and Tips

How to convert the text value "50:23:06" to seconds in Power Query,

AAAbbbnewbie — Tue, 18 Jul 2023 09:38:29 GMT

Hi, how should i convert below time value exceed 24hours to seconds in PBI? Please help~~~

mlsx4 — Tue, 18 Jul 2023 10:14:32 GMT

Hi AAAbbbnewbie :

- First, in Power Query, separate the time by character : (You will get three columns: hours,minutes and seconds).

-Then, create a custom column:

Time= [Other work Hours]*3600+[Other work Minutes]*60+[Other work Seconds]

ppm1 — Wed, 19 Jul 2023 00:01:25 GMT

Add a custom column in the query editor and put this expression in the pop-up box.

let hms = List.Transform(Text.Split([Other Work], ":"), each Number.From(_)), result = hms{0}*60*60 + hms{1}*60 + hms{2} in result

Pat

AAAbbbnewbie — Wed, 19 Jul 2023 02:22:09 GMT

Thank you so much ! it works perfectly for me!

AAAbbbnewbie — Wed, 19 Jul 2023 02:22:23 GMT

Thanks for sharing 🙂