calculating seconds from a numbers/text column which represents the time in hours/minute/seconds

[Anonymous]

In Power Query i have a column which, for example looks like this

9h8m4s

this means 9 hours, 8 minute and 4 second. the challenge now is that i want to convert this value in the column to be the sum up of the hour, minute and second to be only second which actually equals to 32884 seconds.

and ideas about how to convert it in PowerQuery for Power Bi?

[ryan_mayu · Accepted solution]

@Anonymous 

here is a workaround for you. pls see the attachment below

[Anonymous]

oh man, that was so simple and amazing. i was trying to do the same idea but i stuck with "how am i going to do a calucations within the columns" but luckily "Expression.Evaluate" saved the day. thank you so much for your help ❤️

[ryan_mayu]

you are welcome