If the X miles is 100 and the average speed is 30 miles per hour, the time
is 100 / 30 = 3.3333 hours.
Therefore, the Excel formula is =100/30
Tyro
> can any one give me the formula to work out what time it took to do X
> miles at an average speed of Y?
>
> Thanks
>
> Jon
jon - 07 Jan 2008 21:57 GMT
Sorted
Thanks
Jon
> If the X miles is 100 and the average speed is 30 miles per hour, the time
> is 100 / 30 = 3.3333 hours.
[quoted text clipped - 8 lines]
>>
>> Jon
Tyro - 09 Jan 2008 03:00 GMT
Hmm
> Sorted
> Thanks
[quoted text clipped - 13 lines]
>>>
>>> Jon