Entries

Total Min

if(test(prop("Duration"), "[a-z]") or length(replaceAll(prop("Duration"), "[^:]", "")) == 0, toNumber(""), if(length(replaceAll(prop("Duration"), "[^:]", "")) == 2, toNumber(prop("Duration")) * 60, toNumber("")) + if(length(replaceAll(prop("Duration"), "[^:]", "")) == 1, toNumber(prop("Duration")), toNumber(replace(prop("Duration"), "^[^:]*:", ""))) + round(toNumber(replace(replace(prop("Duration"), "^[^:]*:", ""), "^[^:]*:", "")) / 60 * 100) / 100)

Hours

if(length(replaceAll(prop("Duration"), "[^:]", "")) == 2, toNumber(prop("Duration")), toNumber(""))

Minutes

if(length(replaceAll(prop("Duration"), "[^:]", "")) == 1, toNumber(prop("Duration")), toNumber(replace(prop("Duration"), "^[^:]*:", "")))

Seconds

toNumber(replace(replace(prop("Duration"), "^[^:]*:", ""), "^[^:]*:", ""))

00:00 to Hrs/Mins

Entries

00:00 to Hrs/Mins

if(length(replaceAll(prop("Duration"), "[^:]", "")) > 1, toNumber(""), if(length(replaceAll(prop("Duration"), "[^:]", "")) == 0, toNumber(prop("Duration")), toNumber(prop("Duration")) + round(toNumber(replace(replace(prop("Duration"), "^[^:]*:", ""), "^[^:]*:", "")) / 60 * 100) / 100))

Untitled Database

<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>