Retain Field Format From Excel

  • Thread starter Thread starter Lisa W.
  • Start date Start date
L

Lisa W.

I have an excel file that I'm importing to Access. This field consists of
"time"...hours, minutes, seconds. The format in excel is set to "Custom" -
[h]:mm:ss.

The data elements look like 150:27:50, 2:30:25, etc...

The time stays the same for some records but others change. For
example...150:27:50 becomes 6:27:50 AM when imported.

If someone can help me figure a way to retain the format for all records I
would greatly appreciate it.

Thank You,
Lisa W.
 
150 divided by 24 = 6.25 or 6 and 1/4 days which is displayed a 6 AM.
You need to use a text field for datatype to keep the format but you can not
do math on it without massaging.
 
Back
Top