View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
stormy weather stormy weather is offline
external usenet poster
 
Posts: 2
Default Adding running times

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