I'm trying to get the difference in hours(float) between two dates. Say 5.2, when the two dates are 5 hours and 12 minutes apart.
Attempt one: date1 - date 2 (format time interval -> hours)
Attempt two: datediff ({hh}, date1, date2)
Both tries seem to just show the hours as an integer truncating the minutes.
Any help would be greatly appreciated.
Attempt one: date1 - date 2 (format time interval -> hours)
Attempt two: datediff ({hh}, date1, date2)
Both tries seem to just show the hours as an integer truncating the minutes.
Any help would be greatly appreciated.