Sport Times Formats (elapsed time)

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.
 
B

Bob Phillips

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Average elapsed time values? 3
Time format for elapsed time 4
Elapsed Time formatting 3
Limit to hours in elapsed time format? 2
Calculate Elapsed Time: Same Expression Works and Fails Somewhere 3
Time Elapse 3
Calculating/displaying elapsed time TOTALS 3
Conditional formatting with time 4

Top