Format the cells where you enter your times as m:ss.00

Enter the 100th secs as a decimal:

A1 = 5:22.03
A2 = 5:40.20

Then, just use a SUM formula:

=SUM(A1:A2)

Or:

=A1+A2

Format the SUM cell as [m]:ss.00

--
Biff
Microsoft Excel MVP


"stormy weather" wrote in message
...
I'm trying to add my split times for each kilometer for a total of 5 km,
eg.
0:5:22:03 (5 minutes: 22.3 seconds) + 0:5:40:20 etc. What is the
formula
to add these to get 0:11:02:23 - I keep getting 0:0:0:0

Thanks