One Date Field

Timesheet

In Minutes

dateBetween(end(prop("Time Spent")), start(prop("Time Spent")), "minutes")

In Hours

round(dateBetween(end(prop("Time Spent")), start(prop("Time Spent")), "minutes") / 60 * 100) / 100

Formatted

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

Multiple Date Ranges

Timesheet → Multiple Ranges

In Minutes

dateBetween(end(prop("Time 1")), start(prop("Time 1")), "minutes") + dateBetween(end(prop("Time 2")), start(prop("Time 2")), "minutes")

In Hours

round((dateBetween(end(prop("Time 1")), start(prop("Time 1")), "minutes") + dateBetween(end(prop("Time 2")), start(prop("Time 2")), "minutes")) / 60 * 100) / 100

Formatted (00:00)

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

Formatted (00.00hr)