Title: Convert seconds to hours and Minutes (not decimal hours
Convert seconds to hours and Minutes (not decimal hours)
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"
Thanks David but I am not using timestamp fields. I have one field that is minutes in number format.