calculation with minutes

[Paulina]

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

 

[Jon Quixley]

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

 

[Ron Rosenfeld]

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