Excel column of cells representing minutes and secs is created how?

I have tried right clicking on a column the going to Format Cells -->Number-->Custom-->mm:ss .

This does not work though, because when I enter for example 10:20 wanting it to represent 10 minutes and 20 secs, when I move to the next cell the value changes to 20:00 in the cell and in the formula field it says 10:20:00 AM. This is not at all what I want. I am trying to create a column of entries that are mm:ss and then have an avg of these times at the bottom. I didn't think this would be very complicated to create but it it proving to be a major headache. Can anyone help me out.

Hi Mark
When you enter 10:20 excel is assuming
10:20 am....because you have formated the cell
as mm:ss it is only diplaying the 20 sec part
as the mins.
To enter it correctly just enter as
00:10:20

Ivan

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

Archive of Mr Excel Message Board

column of cells representing minutes and secs is created how?

Re: column of cells representing minutes and secs is created how?

Thanks Ivan for the solution.