Type
Date
Calculate total hours of a date range
dateBetween(
dateEnd(prop("Date")),
dateStart(prop("Date")),
"hours"
)
Calculate total days of a date range
round(
dateBetween(
dateEnd(prop("Date")),
dateStart(prop("Date")),
"hours"
)/24,
2
)
Calculate total minutes of a date range
dateBetween(
dateEnd(prop("Date")),
dateStart(prop("Date")),
"minutes"
)
Example: