Hi
as a starting point:
http://www.cpearson.com/excel/DateTimeEntry.htm

--
Regards
Frank Kabel
Frankfurt, Germany
"Lady_luck" schrieb im Newsbeitrag
...
I am formatting a spreadsheet to enter sports-score from a particular
event.
I format cells to display mm:ss using "custom" format [mm]:ss. However the
user, it appears, has to enter 00 for hh to get the display correct. How
can
I avoid this?