Ben SmithBen Smith
Ben Smith/
Timesheets
Timesheets
Timesheets

Timesheets

For
GrowHI
From
Reddit
Status
Updating
Formulas
+
+
dateBetween
dateBetween
empty
empty
dateEnd
dateEnd
format
format
%
%
dateStart
dateStart
Share

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

⚠️
For visual purposes only, you can't use Sum on this column.
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)

⚠️
For visual purposes only, you can't use Sum on this column.
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)

⚠️
For visual purposes only, you can't use Sum on this column.
format(round((dateBetween(end(prop("Time 1")), start(prop("Time 1")), "minutes") + dateBetween(end(prop("Time 2")), start(prop("Time 2")), "minutes")) / 60 * 100) / 100) + "hr"

Related Timesheet

Related Timesheet
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!