G'Day Ed,

Regardless of cell formatting, Excel anticipates time as hh:mm:ss[.0].

If you ENTER 22:30, Excel assumes that the input is hh:mm (10:10 pm).

To 'advise' Excel otherwise you must ENTER
EITHER 00:22:30
OR 22:30.0 (12:22:30 AM for
both).

The cell formatting determines only how the time is displayed.
--
Regards,
Pat Garard
Melbourne, Australia
_______________________

"edbarunning" wrote in message
...
When inputting time that is in minutes and seconds I have to use a decimal
and a zero. i.e. mm:ss.o. Can I reformat so I can input as mm:ss
--
EDba