Tasks

Status

if(and(empty(prop("Started")), empty(prop("Completed"))), "❌ Not Started", if(not empty(prop("Completed")), "✅ Complete", "🔷 In Progress"))

Current Time

if(contains(prop("Status"), "In Progress"), format(dateBetween(now(), prop("Started"), "hours")) + "h " + format(dateBetween(now(), prop("Started"), "minutes") % 60) + "m", "")

Total Time

if(or(empty(prop("Started")), empty(prop("Completed"))), "", format(dateBetween(prop("Completed"), prop("Started"), "hours")) + "h " + format(dateBetween(prop("Completed"), prop("Started"), "minutes") % 60) + "m")

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