Need help with time fields

[haydenbl]

Currently using Access 2007-2010. I have a text file that I am trying to import into Access. I am having issues with the time fields. I need to be able to sum them in a query or report. When I import it in, Access is put the 12:00:00 am as default and adding numbers to achieve the 11 character field. I need to be able to sum these fields later in the database. The file looks like this:

ACD Calls Avg ACD Time Avg ACW Time ACD Time
Totals 103 3:49 1:07 6:33:45
2 1:25 :00 :02:49
8 2:02 :00 :16:15
2 3:17 3:06 :06:34
17 4:49 6:06 1:21:53

Any help you can give me would be greatly appreciated.

 

[gemma-the-husky]

access date times are held as a real number

the number is the number of elapsed days.
the decimal is the fractional part of a day - ie the time

so 12:00:00am is actually the start of a day, correpsonding to a time of 0

now if you add times. eg

=sum(mytimefield)

access will add the times correctly, but say the times add to 3days, plus a bit - access will just show you the time element. The 3 days (ie 72 hours) are still there, but not displayed because of the control format.


so a date/time of say 3.486 represents 3 and a bit days.

turn it into minutes by multiplying by 24 (hours per days) and then 60 (minutes per hour)

hope this helps