The formatting only affects the display of time. If you have formatted the
cell to mm:ss and want to enter 12 minutes, 5 seconds; you still must enter:

00:12:05

you still need to enter those zero hours.
--
Gary''s Student - gsnu200835


"DavARei" wrote:

I have what should be a simple issue.
I'm trying to enter race times as mm:ss and the entry keeps changing to a
date format.
so, if I enter 12:22, Excel changes it to [12:22:00 PM].
However, if I enter 36:22, Excel will change it to [1/1/1900 12:22 PM]

I've tried setting cell format to Custom and selecting the mm:ss option,
I've also tried the h:mm:ss and a few others.
Still no joy, Excel just doesn't want to cooporate.
PLEASE HELP....