Are you setting up Notion templates with formulas for your team? Add this formula in one of our expert-created Notion templates.
Are you setting up Notion templates with formulas for your team? Add this formula in one of our expert-created Notion templates.
Contents
The formula is:
format(dateBetween(end(prop("Date Range Property")), start(prop("Date Range Property")), "days")) + "d " + format(dateBetween(end(prop("Date Range Property")), start(prop("Date Range Property")), "hours") % 24) + "h " + format(dateBetween(end(prop("Date Range Property")), start(prop("Date Range Property")), "minutes") % 60) + "m"
↑ Copy and paste into Notion then switch out the bold property name/s in the formula to match the name of the property name/s you’re using.
The steps to creating a date formula in Notion are:
The steps to editing a date formula in Notion are: