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

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


--
Gary''s Student


"John Kaurloto" wrote:

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

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


"Gary''s Student" wrote in message
...
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


--
Gary''s Student


"John Kaurloto" wrote:

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

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"John Kaurloto" wrote in message
...
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


"Gary''s Student" wrote in
message
...
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


--
Gary''s Student


"John Kaurloto" wrote:

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

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


--
Gary's Student


"John Kaurloto" wrote:

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


"Gary''s Student" wrote in message
...
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


--
Gary''s Student


"John Kaurloto" wrote:

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

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





"Bernard Liengme" wrote in message
...
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"John Kaurloto" wrote in message
...
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


"Gary''s Student" wrote in
message
...
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


--
Gary''s Student


"John Kaurloto" wrote:

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