View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Time it took to travel

=10/28/24, and format as time.
--
David Biddulph

"Steved" wrote in message
...
Hello from Steved

I have a trip which is 10 kilometres

My speed is 28 kilometres per hour

Please what is the formula to give me minutes and seconds it took to do
the
10 kilometres at 28 kilometres per hour.

Thankyou.