I want to enter 346 without having to hit shift colan for the col.

[Gord Dibben]

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

Gord Dibben Excel MVP

 

[CLR]

Format > Custom > #":"##

Vaya con Dios,
Chuck, CABGx3

 

[Myrna Larson]

With, of course, the caveat that the result is not a time, and you can't do
time arithmetic on it.