Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hiya's,
I'm a walker and I like to keep track of my miles and times. I'd like to be able to use excel to figure my miles per hour. I keep track of the miles in a number format..i.e. 8.67 miles. And I keep track of my total times in a time format...i.e. 2:15:13. This would be 2 hours 15 minutes & 13 Seconds. I have no idea how to set up this formula. Any suggestions would be greatly apreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use miles per hour and mileage to estimate travel time | Excel Worksheet Functions | |||
Calculate Mileage | Excel Discussion (Misc queries) | |||
convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
Subtracting based on number of miles | Excel Discussion (Misc queries) |