60 seconds = 1 minute
60 minutes = 1 hour

They both the same "numeric" value.

Since you're locking the minutes to prevent the roll-over to hours,
How about *USING* hours and minutes, and lock the hours to prevent the
roll-over to days?
[hh]:mm

You'll get *exactly* the same display, and your data input will be much
easier then having to enter 0 hours + minutes + seconds.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lady Luck" <Lady wrote in message
...
I am formatting a game sheet for sports events. Time should be entered as
mm:ss which I have "custom" fomatted as [mm]:ss. However I cannot find a
way
to force Excel to read an entry such as 07:28 as 7 minutes and 28 seconds.
It
always assumes the user is entering hours and minutes.
Thanks for any help
SBB