adding race times in minute'second"millisecond format

[tedor]

i'm stuck. i've been trying to add track times together to get the total
time spent on each cup. not much else to say, so i'll show you what i
have.

http://snorland.com/store/tedor/fzeroex.gif
it should add up to... what, 6'20"302?
can't get excel to recognize it.

thanks in advance.
-tedor

 

[JohnI in Brisbane]

tedor,

I entered the times you gave as follows, using format "[m]:ss.000"-

00:42.595
00:45.878
01:22.316
01:36.173
01:46.340
06:13.302


The total cell has -

=SUM(F2:F6)

and uses the same format as the others.

Gave me 6'13"302 as you can see above.

The other alternative is to enter the times as seconds and them that way-

42.595
45.878
82.316
96.173
106.340
373.302


regards,

JohnI

 

[tedor]

used the first method, thanks.
is there any way to input it as x'xx"xxx and have it come out the same
way?

thanks again.
-tedor

 

[JohnI in Brisbane]

tedor,

The best I could do was-

0'42".595
0'45".878
1'22".316
1'36".173
1'46".340
6'13".302


using a format of "[m]'ss\".000"

regards,

JohnI

 

[tedor]

that'll do, thanks for your help.