On Mar 29, 8:23 pm, JE McGimpsey wrote:
One way:

Format/Cells/Number/Custom [m]:ss

In article .com,



"gfkbob" wrote:
I would like to display time in minutes and seconds only even if over
an hour. If the amount of time is 65 minutes I would like it
displayed as 65:00 not 1:05:00. Is this possible in excel?- Hide quoted text -

- Show quoted text -

I am using ms office 2003. I don't see the entry you are speaking
of. I see mm:ss but that doesnot work. it shows 65:00 as 5:00.