dateBetween(end(prop("Time Spent")), start(prop("Time Spent")), "minutes")
round(dateBetween(end(prop("Time Spent")), start(prop("Time Spent")), "minutes") / 60 * 100) / 100
<aside>
⚠️ For visual purposes only, you can't use Sum
on this column.
</aside>
empty(prop("Time Spent")) ? "" : (format(dateBetween(end(prop("Time Spent")), start(prop("Time Spent")), "hours")) + "h " + format(dateBetween(end(prop("Time Spent")), start(prop("Time Spent")), "minutes") % 60) + "m")
dateBetween(end(prop("Time 1")), start(prop("Time 1")), "minutes") + dateBetween(end(prop("Time 2")), start(prop("Time 2")), "minutes")
round((dateBetween(end(prop("Time 1")), start(prop("Time 1")), "minutes") + dateBetween(end(prop("Time 2")), start(prop("Time 2")), "minutes")) / 60 * 100) / 100
<aside>
⚠️ For visual purposes only, you can't use Sum
on this column.
</aside>
and(empty(prop("Time 1")), empty(prop("Time 2"))) ? "" : (format(dateBetween(end(prop("Time 1")), start(prop("Time 1")), "hours") + dateBetween(end(prop("Time 2")), start(prop("Time 2")), "hours")) + "h " + format(dateBetween(end(prop("Time 1")), start(prop("Time 1")), "minutes") % 60) + "m")