@Ihsan-Mahdi wrote:
I'm sorry but my data contains PHIs and I can't share publicly
Anything for an identifier will do, ABC, PDQ, Moose and Squrrel. So make some up with some datetime values that will be similar to your data. The key bits will the datetime variable(s), the structure of the data and the desired output for a given example.
The INTCK function will return counts of intervals. Hours between two datetime values would be:
Hours = Intck('hour',datetime1, datetime2);
if the datetime2 is before datetime1 you get a negative number of hours.