>>I am substracting two datetime values which gives a datetime. Now, with that value, I want to convert that in how many days and how many hours. Is there a function somewhere to do that?
>
>Two datetimes gives you a result in seconds, not a datetime.
>
>seconds = datetime1 - datetime2
>
>days = INT(seconds) / 86400
>
>hours = INT(seconds-86400*days) / 3600
How would I go for the minutes?
I can't seem to find the proper formula.