how to calculate total time in query

[xiaodan86]

Anyone know how to calculate total time in query if the total time
exceed 24 hours?
I wish the total time to be display in number of hours and minutes.

 

[Allen Browne]

See:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

 

[Al Campagna]

If your hours difference will exceed 24hrs, you'll need the Date AND the Time. You
cannot calculate the hours between 12:00 and 12:00 2 days apart without the Dates
involved.
Given a StartDateTime and EndDateTime...
=DateDiff("h","StartDateTime, End DateTime)
will yield total hours bewteen the two.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."