Date/Time Query

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top