Format for elasped time

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

Tom

I am using Excel to track the time and distance of my bike trips.

What format do I use to store the elapsed time? I want
hours:minutes:seconds. I do not want AM or PM or days or calendar days or
days since 1900.

I need to perform arithmetic operations on the time like average speed and
weekly totals.
 
AM or PM is just a format, a day is 1 in excel and an hour is 1/24 so you
can just use

end - start and format as hh:mm:ss for weekly totals if they ever should go
ever 24 hours use custom format [hh]:mm:ss to get average speed km or mile
with distance in A1 and time elapsed in B1

=A1/(B1*24)

format as general or number (most likely you will get a time format but you
need to change that)
 
Tom

Just enter

hh:mm:ss and it will format itself. To get average speeds, etc, you'll need
to understand how excel handles Dates and Times...

Check out here

www.cpearson.com/excel/datetime.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top