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