ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Time it took to travel (https://www.excelbanter.com/excel-worksheet-functions/165937-time-took-travel.html)

Steved

Time it took to travel
 
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.

David Biddulph[_2_]

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.




Steved

Time it took to travel
 
Hello David

I thankyou.

Steved

"David Biddulph" wrote:

=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.






All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com