Formatting time from xxH xxM to a decimal

Hi @Ross1 - Happy to help! You should be able to format those times by splitting the hours from the minutes in the column with a Split column step. You can then Clean the data to remove the letters from those numbers and use an Insert math column step to create those decimals. Finally you can use Format numbers step to make sure the decimals only go out to 2 places. Here is how that will look:

Screen Shot 2023-01-11 at 2.51.29 PM

Here is a snippet of those steps that you can copy and paste into your Flow (how to use a snippet): parabola:cb:7881659e-c4b4-4cf1-a666-f99cad4c9c93

Let us know if you have any questions!

1 Like