Try entering the data as

A1: 0:5:22.3
A2: 0:5:40.2

Then you can add the values:

A6: =SUM(A1:A5)

Format the cells with Format/Cells/Number/Custom h:mm:ss.0

In article ,
stormy weather wrote:

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