Hi
I have managed to work it out myself, so for anybody with simila
problem:

I formated the time cells to text and entered ie 12:00
and entered a change event in the user form text box:

Private Sub txttime_Change()
txttime.Value = Format(ActiveCell.Value, "hh:mm")
End Sub
now all the times read as they should.
cheers
Ber

--
ber
-----------------------------------------------------------------------
bern's Profile: http://www.excelforum.com/member.php...fo&userid=2016
View this thread: http://www.excelforum.com/showthread.php?threadid=46894