MrExcel Publishing
Your One Stop for Excel Tips & Solutions

column of cells representing minutes and secs is created how?

Posted by Mark on December 15, 2001 12:12 PM

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.

Posted by Ivan F Moala on December 15, 2001 12:39 PM

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


Posted by Mark on December 15, 2001 1:15 PM

Thanks Ivan for the solution.

Thanks Ivan for the solution.