Forum Discussion
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 s...
Anonymous
here is a workaround for you. pls see the attachment below
ryan_mayu
Super User
Super UserAnonymous
here is a workaround for you. pls see the attachment below
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