Excel help: Milliseconds

March 23, 2010 at 08:38:01
Specs: Windows XP, 2.16Ghz/2GB
I need to get a simple CSV into Excel, only it doesn't
seem to recognize milliseconds. Does anyone know a
way around this?

The file contains thousands of lines that look like this.
The third and fourth columns contain millisecond
resolution, but excel stops at seconds:


thanks in advance

See More: Excel help: Milliseconds

March 23, 2010 at 08:56:09

Format...Cell...Custom hh:mm:ss.000

Report •

March 23, 2010 at 09:04:17
I tried that.

Prior to Excel import, the time stamp was: 15:15:52.829
After import into excel, the time stamp was: 15:52.8
After the custom cell format, the time stamp is: 00:15:52:800

I feel like I'm getting close, but farther away at the same
time. :)

Report •

March 23, 2010 at 09:29:05

When I paste 15:15:52.829 in a cell it shows as 15:52.8 in the cell and 3:15:53 PM in the formula bar.

As long as I don't click in the formula bar, I can use hh:mm:ss.000 to display 15:15:52.829.

However, if I click in and out of the formula bar, the cell changes to 15:53.0 and hh:mm:ss.000 displays 15:15:53.000.

Time to play!

Report •

Related Solutions

March 23, 2010 at 11:24:25
DerbyDad03, I think with milliseconds the zeros are just place holders. When you pop into the formula bar Excel rounds it off to seconds.
I remember something similar a while back, someone asked about a "Lap Counter" using milliseconds. Can't find the thread.



Report •

March 24, 2010 at 06:49:43
Following DerbyDad's tip on the different results achieved by copying/pasting text into a cell, I changed my script to putput the data into a plain, columned text file and imported it into Excel.

Excel still screwed up the formatting, but I was now able to format the timestamp columns using the hh:mm:ss:000 method. This will do the trick.

Many thanks. I appreciate your help.

Report •

March 24, 2010 at 11:12:22
I'm glad we were able to sneak up on the solution.

Report •

Ask Question