average speed?

  • Thread starter Thread starter William Stokes
  • Start date Start date
W

William Stokes

Hello,

I need to create file that counts an average speed from time. Time is
presented like this 02:31:55 (hrs:min:sec). Is there a ready made function
in Excel for this or do I need to convert to mins/60 and divive km's by this
value? If so how to convert 02:31:55 to minutes?

Thanks
-Will
 
=distance/(time*24)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Hi William

Excel stores times as fractions of a day. So to convert to minutes,
multiply the cell value by 1440 (24*60)
Format the cell with the result as General and you should see
151.9166667
 
Will,

date and times are represented by a floating point number. The integer
part counts days from 1/1/1900 the fractional part is a subdivision of
a day. 1/24 = hour, 1/(24*60) is a minute therefore .75 is 18:00.

you can use date formatting to show the time in the way you want and
the arithmatic is straightforward is you apply the conversion
correctly

hope this helps
 
Back
Top