LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WalkerDude999
 
Posts: n/a
Default Miles Per Hour

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use miles per hour and mileage to estimate travel time OhioSnowBird13 Excel Worksheet Functions 1 February 21st 06 02:11 PM
Calculate Mileage rsikin Excel Discussion (Misc queries) 5 October 1st 05 05:52 PM
convert time from 60 minute hour to 100 minute hour Jboerding Excel Discussion (Misc queries) 2 July 6th 05 11:30 PM
Convert decimal hour into time format? ramdalen Excel Discussion (Misc queries) 2 June 20th 05 06:21 PM
Subtracting based on number of miles Ms Chewie Excel Discussion (Misc queries) 3 December 21st 04 05:35 AM


All times are GMT +1. The time now is 10:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"