Date difference between two dates in hours and Minutes

Q&A
,
5

Sure, the approach is very similar.

To get the seconds between the date/times you can use this formula.

dateDiff({tpep_pickup_datetime},{tpep_dropoff_datetime},"SS")

And for converting the seconds to HH:MM:SS

concat(
ifelse({datediff_SS} / 3600 < 10,concat('0',tostring(floor({datediff_SS} / 3600))),tostring(floor({datediff_SS} / 3600)))
,':',
ifelse(({datediff_SS} % 3600)/60 < 10,concat('0',tostring(floor(({datediff_SS} % 3600)/60))),tostring(floor(({datediff_SS} % 3600)/60)))
,':',
ifelse({datediff_SS} % 60 < 10,concat('0',tostring(floor({datediff_SS} % 60))),tostring(floor({datediff_SS} % 60)))
)