Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

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?

 
Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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 ❤️