Time to miles per hour

I have a spreadsheet that holds times for various biking trips. One column
has the overall time, formatted for time (e.g.- 5:48:00). The next column
has the distance in miles. The third column has a formula that is
Time/distance. I get the time it takes to travel a mile. How do I convert
that to miles per hour? Thanks

Dale

In article <BF29234A.3A1B0%[email protected]>, Dale <[email protected]> wrote:
>I have a spreadsheet that holds times for various biking trips. One column
>has the overall time, formatted for time (e.g.- 5:48:00). The next column
>has the distance in miles. The third column has a formula that is
>Time/distance. I get the time it takes to travel a mile. How do I convert
>that to miles per hour? Thanks

...and how many times can you travel that mile in an hour ?


Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)

hello Dale,

I got an idea,try this:
column A time
column B distance
C D E F
G
speed time hour minute second
=B2/D2 =E2+F2/60+G2/3600 =hour(A1) =minute(A1) =second(A1)

hello Dale,


I got an idea,try this:
column A time
column B distance

speed time hour minute
second
=B2/D2 =E2+F2/60+G2/3600 =hour(A1) =minute(A1) =second(A1)

After Friday's ride, I think one of the miles is enough!!!
"Bruce Sinclair" <[email protected]> wrote
in message news:[email protected]...
> In article <BF29234A.3A1B0%[email protected]>, Dale
> <[email protected]> wrote:
>>I have a spreadsheet that holds times for various biking trips. One column
>>has the overall time, formatted for time (e.g.- 5:48:00). The next column
>>has the distance in miles. The third column has a formula that is
>>Time/distance. I get the time it takes to travel a mile. How do I convert
>>that to miles per hour? Thanks
>
> ..and how many times can you travel that mile in an hour ?
>
>
> Bruce
>
> ----------------------------------------
> I believe you find life such a problem because you think there are the
> good
> people and the bad people. You're wrong, of course. There are, always and
> only, the bad people, but some of them are on opposite sides.
>
> Lord Vetinari in Guards ! Guards ! - Terry Pratchett
>
> Caution ===== followups may have been changed to relevant groups
> (if there were any)
>

Thanks so much. I got it to work using the hour, minute, second formulas. I
had to rethink how I manually calculated the mph, then it was pretty simple.
You learn something new everyday, and this was it! Again, thanks.

Dale

> hello Dale,
>
> I got an idea,try this:
> column A time
> column B distance
> C D E F
> G
> speed time hour minute second
> =B2/D2 =E2+F2/60+G2/3600 =hour(A1) =minute(A1) =second(A1)
>

=distance/time/24
or
=distance/(time*24)
and formatted at a number. Excel times are stored as a decimal fraction
of a day (time displays are handled by formatting), so you have to
distance/time gives miles/day, so you have to convert it to miles/hour.

Jerry

Dale wrote:

> I have a spreadsheet that holds times for various biking trips. One column
> has the overall time, formatted for time (e.g.- 5:48:00). The next column
> has the distance in miles. The third column has a formula that is
> Time/distance. I get the time it takes to travel a mile. How do I convert
> that to miles per hour? Thanks
>
> Dale

Hi,

I did it the following way:

DISTANCE/(HOUR(X) + (MINUTE(X)*100/60)/100

1. DISTANCE is the cell containing your travelled distance
2. you devide the distance by the following:

X is the cell containing the time you filled
so:
(HOUR(X) + (MINUTE(X)*100/60)/100

I use it in the sheet I have loaded in my PDA when I go on vacation, I have include fuel consumption and time going form A - B thus calculating also the mean speed, etc.

I hope it helps,

Hans