Thanks for the reply.
This does make the display appear the way it should, but it does still
appear to read (in the bar above) as [12:12:05 am] as if 12 minutes and 5
seconds is started from midnight ...
This will have to suffice.

Thanks again

"Gary''s Student" wrote:

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....