Time Format Autofill

[SiH23]

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.

 

[MartinW]

Hi Simon,

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

HTH
Martin