Elapsed time

  • Thread starter Thread starter nlaman
  • Start date Start date
N

nlaman

I have a datafield in Excel that is elapsed time (i.e.,
ranges from 00:00 - 59:59) and I want to import it into
Access 2000 and maintain the elapsed time format. Access
converts an elapsed time value (18:28-18 min 28 sec) to a
clock time format (6:28 PM or 1828 hours).
Can this be circumvented at the time of Import and if so,
how?
 
Suggestion 1: if your data is time between 0 and 1 minute, try
formatting your cells in Excel as hh:mm:ss and then import.

Suggestion 2: The cells may be formatted in Excel to appear as elapsed
time, but their underlying data type is Double (float) and so the
actual range is 0 to 0.0416550925925926. Remove formatting to show the
data as Double then do the import. You could then in MS Access change
the column's data type to Date.
 
Back
Top