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" <(E-Mail Removed)> schrieb im Newsbeitrag
news:4659eb9a$(E-Mail Removed)...
> 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

> 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

(E-Mail Removed)
(E-Mail Removed) with @tiscali.co.uk


"jon" <(E-Mail Removed)> wrote in message
news:4659eb9a$(E-Mail Removed)...
> 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
>
>
>
>

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" <(E-Mail Removed)> wrote in message
news:4659eb9a$(E-Mail Removed)...
> 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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:4659eb9a$(E-Mail Removed)...
>> 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
>>
>>
>>
>
>

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" <(E-Mail Removed)> wrote in message
news:465a02dd$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:4659eb9a$(E-Mail Removed)...
>>> 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
>>>
>>>
>>>
>>
>>
>
>

> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:465a02dd$(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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" <(E-Mail Removed)> wrote in message
>>> news:4659eb9a$(E-Mail Removed)...
>>>> 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
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>