View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default Elapsed Time formatting

"pasajescultura" wrote in message
...
I am a competitive runner and I want to use excel to track my workout data.
I want excel to recognize my mile times, etc. as elpased times, so that I
can
add them together/average them and that kind of stuff. Is there any way
that
I could enter something like 4:57, 5:03, 5:00 (examples of mile times in
min:sec) and have it return a cumulative time and an average time. I
don't
want these times to get confused for times of day. Appreciate the help!


Format your cells as [h]:mm and then use normal functions (SUM, AVERAGE,
etc.)