<aside> ⚠️ This formula assumes the time entered in Duration starts with a number, has both hours and minutes (even if there were 0 hours), and is separated by one space. It will ignore the letters.
</aside>
toNumber(prop("Duration")) * 60 + toNumber(replace(prop("Duration"), "[^ ]+", ""))
toNumber(prop("Duration"))
Converts Duration to a number, which will pick up the first number it finds and ignore the rest.
* 60
Multiplies the result by 60 to convert hours to minutes.
+ toNumber(replace(prop("Duration"), "[^ ]+", ""))
Adds the remaining minutes. This is found in the Duration property by removing everything before the first space and then converting that result to a number.
<aside> ⚠️ This formula assumes the time entered in Duration starts with a number, has both minutes and seconds (even if there were 0 minutes), and is separated by one space. It will ignore the letters.
</aside>
round((toNumber(prop("Duration")) * 60 + toNumber(replace(prop("Duration"), "[^ ]+", ""))) / 60 * 100) / 100