View Single Post
  #1   Report Post  
Paulina
 
Posts: n/a
Default 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