Data Time Lapse Greater than 24 hours

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing data from Excel to an Access table and some of the "timed"
data is longer than 24 hours. I need to be able to calculate, or run a query
based on what the longest time lapse was -- as well as other important
information about the event. If I format the Time field as "Date/Time" I
can't do that. If I format it as a number, I'm not sure how to get it back
into time format to use in my calculations.

Thank you in advance for your assistance.
 
Not sure what you are asking, but I think you are mistakenly saving
"durations" in a date/time field. That is not correct. A time field is for
a particular point in time. (Twelve O'clock yesterday 12:00:00) A duration
would be stored as a number (twelve and a half hours = 12.5)
 
OK. So I am importing "durations" as you put it.
Now, how do I translate that back to hh:mm:ss for the reports and queries. I
also need to add up all the durations for a particular "date" which is in a
separate field.
 
You can sum the time values like you would any other numeric value. The only
issue is displaying your value in a time format if that is what you think
you need.

Doug Steele has a function that allows you to format your date/time value in
many different formats. Check this link
http://www.accessmvp.com/djsteele/Diff2Dates.html.
 
Back
Top