Even though you format the cells as mm:ss, when you actually enter the data,
you would need to enter it in hours:minutes:seconds, so, when entering data,
you would enter:
00:00:40, then it will display correctly.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Theresa" wrote:

Hi,

I need to enter times in a column (Excel 2003). For example, "00:40" -
meaning 40 secs. I've formatted the column as mm:ss, however when I enter
00:40, it converts the value to 40:00 in the cell, and reads 12:40 AM in the
status bar.

Any help would be greatly appreciated, thanks!
Theresa