View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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