LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 164
Default Time, Distance, Speed

I have sheet with columns listed as distance and time. An example of the
values in these columns are distance 5.0 km and the time column is
00:52:30.15 what type of formula would I would I need for a value in a
kilometre per hour column. TIA

--

Regards
Michael Koerner



 
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
Calculating Time from Speed and Distance? John[_6_] Excel Worksheet Functions 4 April 3rd 23 04:37 PM
How do I get speed given time (hh:mm:ss) and distance in Excel? Charlie_007 Excel Worksheet Functions 1 September 24th 06 05:02 AM
How to calculate speed given distance and mm:ss time format? rrl Excel Discussion (Misc queries) 1 October 21st 05 05:39 PM
time/distance calculation KJO Excel Worksheet Functions 1 April 20th 05 09:13 PM
Time and distance formula drumnotme118 Excel Worksheet Functions 2 November 20th 04 06:22 AM


All times are GMT +1. The time now is 11:33 AM.

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

About Us

"It's about Microsoft Excel"