excel sum miliseconds

[Bllich]

Hy, I apologize for being maybe a little off topic

the problem is ..

in excel
A1
0:42:58
A2
0:20:30
A3 (=sum a1+a2)
1:03:28

if this is hh:mm:ss its ok! I don't even have to format cells or anything


BUT I have this:

mm:ss,xxx

this xxx is miliseconds and I don't know how to do this:
for example:
A1
01:58,250
A2
02:30,900

A3 (=sum a1+a2)
04:29,150

I don't know how to get this sum in A3 ??

help please

Ivan

 

[Bob Phillips]

Isn't that answer correct?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bllich]

Isn't that answer correct?

it is, 'cause I did the summing..
but I wont do it for 5000 records...
I have to set excel to do it for me..
so if I knew how to make this example work...
with giving him A1 and A2 to him: give me A1+A2

 

[Bob Phillips]

So maybe

=SUM(A1:A5000)

perhaps?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bllich]

So maybe

=SUM(A1:A5000)

perhaps?

no no no..
he he, you're a funny guy Bob.

I calculated a1+a2 on my own, or how should I say "on paper"...
the problem is in Excel .. i can't do a3=a1+a2 because i have those ,xxx miliseconds
it doesn't work like that... try .. I need some programers trick!
if I was in Pascal - I would have no trouble at all..

sorry for lack of right english terms..
I'm from Croatia

 

[JE McGimpsey]

This works for me:

A1: 0:00:01,234
A2: 0:00:04,567
A3: 0:00:07,890

B1: =SUM(A:A) ===> 0:00:13,691

when all cells are formatted with

Format/Cells/Number/Custom h:mm:ss,000

No programmer's trick needed.

when all In article <[email protected]>,

 

[Bllich]

This works for me:

A1: 0:00:01,234
A2: 0:00:04,567
A3: 0:00:07,890

B1: =SUM(A:A) ===> 0:00:13,691

when all cells are formatted with

Format/Cells/Number/Custom h:mm:ss,000

No programmer's trick needed.

when all In article <[email protected]>,

I did that a couple of times.. no, shit.. I did ##":"##,000 for the records
and then I expected to turn the cell that had the result in h:mm:ss,000...but the
thing was that I got 70 seconds for example and I needed Excel to write me 1min
10sec instead.. so I thought about mod() bla bla

And it had to be so trivial!! ..

Thanks!

 

[Bob Phillips]

That wasn't meant to be funny, it was how I interpreted your request. Like
JE, it works for me, but I use a format of [h]:mm:ss.000

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bllich]

That wasn't meant to be funny, it was how I interpreted your request.
Like JE, it works for me, but I use a format of [h]:mm:ss.000

thanks!