Post your code, and someone will be able to help.

Pete

On Nov 30, 10:19 am, hol wrote:
I am using a vb code that when entering hours and minutes it adds colon
between the hours and minutes. ie if I enter 105 it gives 1:05.
The code is working find for some cells, but every now and then it throws a
track!

For instance the above example it gives me 2520:00 instead of 1:05.
Any ideas?????

--
hol