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

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

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

Are you entering the fractions of a second as a decimal or with a colon like
in your example?

Should be 0:5:22.03 and 0:5:40.20

Regards,

OssieMac

"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

Thank you all -- It works!

"OssieMac" wrote:

Are you entering the fractions of a second as a decimal or with a colon like
in your example?

Should be 0:5:22.03 and 0:5:40.20

Regards,

OssieMac

"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