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