J
Joe
I am running a query that calculate the difference between two times and I
would like the results in h:mm format
If the difference is 2.5 days, the query returns 12 hours, but leaves the 2
days off.
However, if the difference is .25 of a day, the query correctly returns 6
hours
For 1.5 days I would like it to return 36:00 which is 36 hours...currently
it returns 12 as anything over 24 is lost.
Any help appreciated.
would like the results in h:mm format
If the difference is 2.5 days, the query returns 12 hours, but leaves the 2
days off.
However, if the difference is .25 of a day, the query correctly returns 6
hours
For 1.5 days I would like it to return 36:00 which is 36 hours...currently
it returns 12 as anything over 24 is lost.
Any help appreciated.