Sport Times Formats (elapsed time)

  • Thread starter Thread starter Tom Mozden
  • Start date Start date
T

Tom Mozden

Does anyone have the definitive word on how to handle
elapsed time? I need to track and manipulate swimtimes in
Excel. Excel gets SO confused, and converts the times
into various items.

I can't believe that after 10yrs of using Excel, this
ability is either missing or so hard to use.

Please enlighten me!

Thanks,
Tom M.
 
Tom,

As you refer to swimtimes, I assume you want 1/100th of a sec.

All you need to do is format the cells, including the result cell, as
hh:mm:ss.00 and just subtract the end time from the start time. As Excel
stores time as a fraction of 1 day, it is straightforward to apply math to
it.
 
Back
Top