calculating speeds in mph
Good call Bob.
Thanks very much
--
Jock Waddington
"Bob Phillips" wrote:
To get mph
=A1/(B1*24)
where A1 is distance, B1 is time in time format.
Make sure you format result cell as General, it will default to time
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Jock W" wrote in message
...
How do I calculate how fast something has travelled?
I have a distance (2 miles) and the time taken (00:22:00).
The time cell is formatted as hh:mm:ss.
Thanks
--
Jock Waddington
|