Thats brilliant thanks Bob. I have had a good read and implemented this. I
even managed to make a few changes specific to the way time is likely to be
input. I amazed myself!!!

I have one further question. When using that code if a user inputted the
time as 10:00 and actually used the colon then it throws up the incorrect
time entered error. Is there anyway of surpressing that in case the more
conscientious users input the time in its full and correct format?

Thanks for all your help Bob

"Bob Phillips" wrote:

See http://www.cpearson.com/excel/DateTimeEntry.htm

--
__________________________________
HTH

Bob

"Pyrite" wrote in message
...
Hi,

I have a column for enginners to enter the time an appointment starts. I
want this column to look like 10:00, 12:00, 14:00 and so on. Not those
exact
numbers, just that format. I went to format cells and all the time formats
include seconds or dates so I went to custom formats. On here I found
hh:mm
which is exactly what I need. The only problem is that if I simply enter
10
for instance meaning 10am (as many engineers will) for some reason the
time
remains at 00:00 and a date is added before it, usually a date in Jan
1900.
Is there anyway of forcing it to only format to hh:mm?