Choose Time as your return type. On your layout, use hhmm as your data format (or choose hhmmss if you want).
Thanks Phil - that was the inspiration I needed - my problem was NOT choosing 24 hours for the formating -
what if I wanted return days Hours min ?
Then you'd need to craft your own calculation to separate out the days.
There are 86400 seconds in a day, 3600 in an hour, 60 in a minute. Ts1 and Ts2 are your two time stamp fields.
Let ( [ I = Ts2 - Ts1 ;
D = Div ( I ; 86400 ) ;
H = Div ( Mod ( I ; 86400 ) ; 3600 ) ;
M = Round ( ( I - ( D * 86400 ) - ( H * 3600 ) ) / 60 ; 0 ) ]
D & " Days " & H & " hours " & M & " minutes"
Brilliant - thank yu Phil