calculation with minutes
 

Hi!
I have a problem with a calculation in excel. I have one column for
stretch?(how long the way is in kilometer) and one column for the time it
takes to go, this is formatted in tt:mm:ss. Now I want to know the
minutes/km and I want it displayed in minutes and seconds, mm:ss, (and not
like 2,99 minutes like it is now). I can do the math with a paper and pencil
but I don't know how to make excel do what I want and also show it like I
want. Can somebody please help me?
/Lina

Hi Pauline

I might be missing something here, but if you have a distance of (say)
15.55 km in cell A1 and the time it takes in cell A2 as 2:15:15 (2hrs,
15min, 15 sec), then the answer is A2/A1 with the answer cell A3
formatted in the same way as cell A2. I think that in fact Excel will
format the cell in time hh:mm:ss automatically

Regards
Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=471353

On Wed, 28 Sep 2005 12:11:22 +0200, "Paulina" wrote:

Hi!
I have a problem with a calculation in excel. I have one column for
stretch?(how long the way is in kilometer) and one column for the time it
takes to go, this is formatted in tt:mm:ss. Now I want to know the
minutes/km and I want it displayed in minutes and seconds, mm:ss, (and not
like 2,99 minutes like it is now). I can do the math with a paper and pencil
but I don't know how to make excel do what I want and also show it like I
want. Can somebody please help me?
/Lina


=time/stretch

Format as m:ss"/km"


--ron