Ben SmithBen Smith
Ben Smith/
Total Hours
Total Hours
Total Hours

Total Hours

For
amoonlitdream
From
Reddit
Status
Updating
Formulas
dateBetween
dateBetween
/
/
dateEnd
dateEnd
empty
empty
if
if
|| · or
|| · or
dateStart
dateStart
-
-
toNumber
toNumber
Share

Time 1

if(empty(prop("Start")) or empty(prop("End")), toNumber(""), dateBetween(prop("End"), prop("Start"), "minutes") / 60 - 0.5)
 

Time 2

if(contains(format(prop("Start & End")), "-"), dateBetween(end(prop("Start & End")), start(prop("Start & End")), "minutes") / 60 - 0.5, toNumber(""))
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!