average speed?

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)

"William Stokes" <[email protected]> wrote in message
news:eA%[email protected]...
> 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
>
>

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

--
Regards

Roger Govier


"William Stokes" <[email protected]> wrote in message
news:eA%[email protected]...
> 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
>
>

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