Entries
Text → Number
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.
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.
* 60Multiplies 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.
Minutes
Entries
Duration to Decimal Minutes
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.
round((toNumber(prop("Duration")) * 60 + toNumber(replace(prop("Duration"), "[^ ]+", ""))) / 60 * 100) / 100
