Replace values based on function

[RPAI2812]

Hi, I have a column from a table that the database is not following a standard as from picture below. I need to have the time information in hours as a number, but the person that fills the database sometime fills with strings such as "h" for hours and "min" for minutes. I would like to create a function in PQ that transforms these cases of texts to the correct number value. In other words, I would like to change "h" for a comma, erase the word num and the value of minutes I would have to divide by 60 to have its decimal values in hours.

I am not very much familiar with coding in PQ, so I kindly ask someone's help 🙂

[smpa01 · Accepted solution]

@RPAI2812  in PQ replace "h" with comma(,) and then split on first delimiter (,)

[RPAI2812]

An additional relevant information is that I don't have access to edit the database