Hi

I have a time tracking spreadsheet where I want to have a sort of validation where the user can type 12 in a cell and when they press enter it changes automatically to 12:00
Anyone know how I can achieve this?

TIA