How to convert days hours mins into seconds

[jimb1955]

I have a business duration column that shows Days hours minutes, It's currently text based and Unfortunately the way DB setup it can't be changed in Transform data to date/time, number or decimal without getting an error. In order for my measure to work it need to be in seconds or decimal. So how can I convert example show below into a column to show total seconds or decimal? 

[amitchandak · Accepted solution]

@jimb1955 , My advice would be, Split by Delimiter in Power Query, you will get 6/8 columns

Then Create a new column

[Day]*24*3600 +[Hour]*3600 + [Minute]*60 + [Second]

Split Column Power Query: https://youtu.be/FyO9Vmhcfag

Another way is Text.Split and then use the index on list and Number.FromText to create a new column

Text.Split: https://youtu.be/Fn5mNEuRNVg

refer this example

Created distinct sorted comma-separated text from unsorted text: https://youtu.be/4bV30FEFjEM