title: Excel 2007: How to display mm:ss format not as a DateTime (e.g. 73:07)?
body: <p>I need to create and Excel table that computes daily training times. each row has the following fields: Date, Distance, Time and Minutes/Km.<br/> My main problem is that I want to display the Time in format of <code>mm:ss</code>. For example: 24 min and 3 sec should be <code>24:03</code>, but "Excel" turns it to 00:03:00 (3 min after midnight). I've tried setting up "special formatting" but still "Excel insists" on formatting the hours. More over, training may exceed 60 minutes and I still want it only as <code>mm:ss</code><br/>
  My second question is after I'm done with the formatting issue, what is the simple way to compute Time/Distance?</p>