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

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