Hi Ken,

I think you are on the wrong track with
trying to convert something wrong into something right.

The complications would be endless.

You should try to prevent something wrong inserted
in a cell beforehand.

If you can't use a datetimepicker-control or whatever,
I think, you better set up two dropdown-listboxes,
one for the hour, the other for the minute,
or try some other method for selecting from
predefined values.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"