Formatting time from xxH xxM to a decimal

I have durations of time that are formatted as xH xxM (4h 10m). I have custom functions in sheets that need numbers expressed as decimals to work. For the above example it would output 4.17. Is there a way in parabola to make this conversion and replace the existing data in the cell?

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