how to calculate total time in query

X

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.
 
A

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."
 
Top