LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Don
 
Posts: n/a
Default A formula to express distance per minute ....

Hi all,
Given time in mm:ss and distance in general decimal form (eg 5.5 miles) is
there an effective way to write a formula to express the distance per minute?
I have tried a few things - to no avail ....
Also, I have a particular excell cell formatted as mm:ss - however I note I
always have to input data into cell in hh:mm:ss format? If I exclude 'hh'
(which is always 00) I get a meaningless data representation .... Is this
right?
thx,
Don-
 
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
IF & VLOOKUP FORMULA taxmom Excel Worksheet Functions 3 March 2nd 05 03:35 PM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM
How to express $A:$A with formula Tetsuya Oguma Excel Worksheet Functions 2 December 16th 04 02:36 AM
Time and distance formula drumnotme118 Excel Worksheet Functions 2 November 20th 04 06:22 AM


All times are GMT +1. The time now is 08:17 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"