Formatting for and adding thousandths of a second

[John Kaurloto]

To the group:

Are there any means of formatting cells to include thousandths of seconds?
And then Summing those times?

I know hh:mm:ss - standard time formatting. This adds perfectly, but I am
in need of a time entry of
Hours, Minutes, Seconds, tenths, hundredths, thousandths of seconds.

Any help or suggestions greatly appreciated.

Thank you, most kindly.

John

 

[Guest]

Colons help to define the fields and avoid confusion. You can set up custom
formatting that will allow you to work in thousandths of a sec:

hh:mm:ss.000 with more than necessary precision:
formatted general
01:00:00.000 0.041666666667
00:01:00.000 0.000694444444
00:00:01.000 0.000011574074
00:00:00.100 0.000001157407
00:00:00.010 0.000000115741
00:00:00.001 0.000000011574

 

[John Kaurloto]

Thank you.

Formatting with the zeros will allow me to enter the appropriate value, but
when I attempt to add the column of time values formatted in that manner,
the result is 00:00:00:000
Without the zeros the column adds perfectly, as if Excel, while allowing me
to enter the value, cannot compute any format but hh:mm:ss
I could certainly being doing something totally incorrect, but while the
format works, the math doesn't.
Any ideas as to why this would be so? Am I doing something wrong?

Again, my sincere thanks.

John

 

[Bernard Liengme]

I think you misread Gary's reply.
The format is h:mm:ss.000 with a decimal before the final 000 not a colon.
I was able to add up the same values he gave.
best wishes

 

[Guest]

Let's first make sure the format is correct. I format cells A1,A2,A3 as
General
hh:mm:ss.000
note that the last field starts with a period rather than a colon

In A1 I put:
02:31:15.015

In A2 I put:
01:10:12.100

In A3 I enter:
=A1+A2
and I see:
03:41:27.115


So the math works. The same three cells, if displayed with "normal" format
would be:
0.105034896
0.048751157
0.153786053

 

[John Kaurloto]

Well I certainly win the Twit Of The Year Award!

My gracious thanks to you both.

Now, if you'll pardon me, I am off to the ophthalmologist...