| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Travel sheet in Excel 2003 | New Users to Excel | |||
| Travel time problem | Excel Worksheet Functions | |||
| travel expenses by month | Excel Discussion (Misc queries) | |||
| How to use miles per hour and mileage to estimate travel time | Excel Worksheet Functions | |||
| currency convertor-travel expense | Excel Worksheet Functions | |||
Linear Mode
