convert time format to decimal format for excel?

T

Tim

i want to convert a time format in an access table of the format
HH:MM:SS.SSSSSS so I can export it to excel and then graph it. With the
current format, it exports it and excel sticks a ' in front of it indicating
a text field, hence the need to convert it to a decimal format. Any ideas?
 
J

Jerry Whittle

Access doesn't support millisecond so I'm guessing by your format that the
time isn't stored in a true date/time data type field. Therefore you probably
need to manipulate the text after it gets into Excel.
 

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

How to convert decimal year to date format in excel 2
Access Convert a decimal time to hours and minutes 2
Convert time format to decimal format 3
Convert WAV to MP3 4
Hanging decimal places with custom number format 2
Number Format 2
Converting standard time to decimal time 2
Format in Text Field Changes 6

Top