Retain Field Format From Excel

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.
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retaining Time Format when Importing 1
Adding and Subtracting Times 1
Excel macro to edit cell format 0
How do I convert time as text 'mm:ss to time value in Excel 5
Time Calculations 2
Formatting short times 2
Time table 3
Fail to hibernate..more evidence 11

Top