<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
<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>