I would be really grateful if someone could offer some help.

I have formatted a cell to accept the time format HH:MM, but when I type in
a value say 3 it converts to 00:00 instead of 03:00. Why is this?

Any help or assistance would be greatly appreciated.

Many thanks,

Simon.