Adding running times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Thank you all -- It works!

OssieMac said:
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
Click to expand...
 
Back
Top