how to calculate total time in query

  • Thread starter Thread starter xiaodan86
  • Start date Start date
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.
 
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."
 
Back
Top