View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock W
 
Posts: n/a
Default calculating speeds in mph

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