Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
AAAbbbnewbie
Frequent Visitor

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

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

 

AAAbbbnewbie_0-1689673058678.png

 

1 ACCEPTED SOLUTION
ppm1
Solution Sage
Solution Sage

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

Microsoft Employee

View solution in original post

4 REPLIES 4
ppm1
Solution Sage
Solution Sage

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

Microsoft Employee

Thank you so much ! it works perfectly for me! 

mlsx4
Super User
Super User

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]

 

 

Thanks for sharing 🙂 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.