Hi Simon,

Chip Pearson has one way to do that here.
http://www.cpearson.com/excel/DateTimeEntry.htm

HTH
Martin


"SiH23" wrote in message
...
I wonder as to whether anyone could help?

I am completing a time recording spreadsheet and would like it set so if 2
is placed within a cell it will autofill to 02:00 - is this posssible.

Many thanks,

Simon.