Average speed

Hi all
Having trouble working out average speed.

miles in a1 =14.3
time in B1 = 0:50:23 this cell has been formatted to HH:MM:SS

The formula A1/B1 brings back the wrong answer if I alter to A1/(B1*24)
still does not work correctly.

Advise please.

Thanks

Jon

Jean
Sun May 27 16:02:42 CDT 2007


"jon" <jon@nospam.com> schrieb im Newsbeitrag
news:4659eb9a$1_1@glkas0286.greenlnk.net...
> Hi all
> Having trouble working out average speed.
>
> miles in a1 =14.3
> time in B1 = 0:50:23 this cell has been formatted to HH:MM:SS
>
> The formula A1/B1 brings back the wrong answer if I alter to
> A1/(B1*24) still does not work correctly.
>
> Advise please.
>
> Thanks
>
> Jon


Jon,

Probably formatting the answer as a number will solve your problem

regards

Jean

Sandy
Sun May 27 16:04:23 CDT 2007

> still does not work correctly.
It would have been better if you had said what result you got.

Did you re-format the result cell as General?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"jon" <jon@nospam.com> wrote in message
news:4659eb9a$1_1@glkas0286.greenlnk.net...
> Hi all
> Having trouble working out average speed.
>
> miles in a1 =14.3
> time in B1 = 0:50:23 this cell has been formatted to HH:MM:SS
>
> The formula A1/B1 brings back the wrong answer if I alter to A1/(B1*24)
> still does not work correctly.
>
> Advise please.
>
> Thanks
>
> Jon
>
>
>
>

T
Sun May 27 16:14:51 CDT 2007

What result do you expect?

If you want the average time per mile you should divide B1 by A1:

=B1/A1

Result = 0:03:31

Biff

"jon" <jon@nospam.com> wrote in message
news:4659eb9a$1_1@glkas0286.greenlnk.net...
> Hi all
> Having trouble working out average speed.
>
> miles in a1 =14.3
> time in B1 = 0:50:23 this cell has been formatted to HH:MM:SS
>
> The formula A1/B1 brings back the wrong answer if I alter to A1/(B1*24)
> still does not work correctly.
>
> Advise please.
>
> Thanks
>
> Jon
>
>
>

jon
Sun May 27 17:29:22 CDT 2007

Hi

some figures I have from the spread sheet are

distance 23.44 miles
time 1:41:59
Average speed 13.7 MPH

the result I get is 23:19:17 not the 13.7 it should be.

I want to check the aververage speed after a calculation which alters the
time and distance

Jon

"T. Valko" <biffinpitt@comcast.net> wrote in message
news:OINITQKoHHA.4900@TK2MSFTNGP05.phx.gbl...
> What result do you expect?
>
> If you want the average time per mile you should divide B1 by A1:
>
> =B1/A1
>
> Result = 0:03:31
>
> Biff
>
> "jon" <jon@nospam.com> wrote in message
> news:4659eb9a$1_1@glkas0286.greenlnk.net...
>> Hi all
>> Having trouble working out average speed.
>>
>> miles in a1 =14.3
>> time in B1 = 0:50:23 this cell has been formatted to HH:MM:SS
>>
>> The formula A1/B1 brings back the wrong answer if I alter to A1/(B1*24)
>> still does not work correctly.
>>
>> Advise please.
>>
>> Thanks
>>
>> Jon
>>
>>
>>
>
>

jon
Sun May 27 18:46:25 CDT 2007

Sorted

I had some formatting in the cell I did not know about and had to times the
time by 24

Thanks everyone

Jon


"jon" <jon@nospam.com> wrote in message
news:465a02dd$1_1@glkas0286.greenlnk.net...
> Hi
>
> some figures I have from the spread sheet are
>
> distance 23.44 miles
> time 1:41:59
> Average speed 13.7 MPH
>
> the result I get is 23:19:17 not the 13.7 it should be.
>
> I want to check the aververage speed after a calculation which alters the
> time and distance
>
> Jon
>
> "T. Valko" <biffinpitt@comcast.net> wrote in message
> news:OINITQKoHHA.4900@TK2MSFTNGP05.phx.gbl...
>> What result do you expect?
>>
>> If you want the average time per mile you should divide B1 by A1:
>>
>> =B1/A1
>>
>> Result = 0:03:31
>>
>> Biff
>>
>> "jon" <jon@nospam.com> wrote in message
>> news:4659eb9a$1_1@glkas0286.greenlnk.net...
>>> Hi all
>>> Having trouble working out average speed.
>>>
>>> miles in a1 =14.3
>>> time in B1 = 0:50:23 this cell has been formatted to HH:MM:SS
>>>
>>> The formula A1/B1 brings back the wrong answer if I alter to A1/(B1*24)
>>> still does not work correctly.
>>>
>>> Advise please.
>>>
>>> Thanks
>>>
>>> Jon
>>>
>>>
>>>
>>
>>
>
>

Dana
Thu May 31 00:50:17 CDT 2007

> I had some formatting in the cell I did not know about

Just two cents. Most likely, when you entered =A1/B1, Excel was "helping"
you by automatically formatting the cell to the same Time Format as cell B1.
I'm sure you know, but the time in B1 is a fraction of a day, so the formula
=A1/B1 is actually Miles/Day. One divides by 24 to get Miles/Hour.
A custom format (or style) of #.## "mph" can sometimes be helpful.

--
Dana DeLouis
Windows XP & Excel 2007


"jon" <jon@nospam.com> wrote in message
news:465a14e9_1@glkas0286.greenlnk.net...
> Sorted
>
> I had some formatting in the cell I did not know about and had to times
> the time by 24
>
> Thanks everyone
>
> Jon
>
>
> "jon" <jon@nospam.com> wrote in message
> news:465a02dd$1_1@glkas0286.greenlnk.net...
>> Hi
>>
>> some figures I have from the spread sheet are
>>
>> distance 23.44 miles
>> time 1:41:59
>> Average speed 13.7 MPH
>>
>> the result I get is 23:19:17 not the 13.7 it should be.
>>
>> I want to check the aververage speed after a calculation which alters the
>> time and distance
>>
>> Jon
>>
>> "T. Valko" <biffinpitt@comcast.net> wrote in message
>> news:OINITQKoHHA.4900@TK2MSFTNGP05.phx.gbl...
>>> What result do you expect?
>>>
>>> If you want the average time per mile you should divide B1 by A1:
>>>
>>> =B1/A1
>>>
>>> Result = 0:03:31
>>>
>>> Biff
>>>
>>> "jon" <jon@nospam.com> wrote in message
>>> news:4659eb9a$1_1@glkas0286.greenlnk.net...
>>>> Hi all
>>>> Having trouble working out average speed.
>>>>
>>>> miles in a1 =14.3
>>>> time in B1 = 0:50:23 this cell has been formatted to HH:MM:SS
>>>>
>>>> The formula A1/B1 brings back the wrong answer if I alter to A1/(B1*24)
>>>> still does not work correctly.
>>>>
>>>> Advise please.
>>>>
>>>> Thanks
>>>>
>>>> Jon
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>