Possible to enter 1200 instead of 12:00 (much faster)

[R.E.Nyland]

Office 2003, sp1: In my work, I often enter hours (12:45, 22:37...) into the
cells in excel. The need for entering the ":" between hours and minutes is a
real pain, to be honest. It would speed up and make much more comfortable the
process, if I could just enter 1245 and 2237. I would actually like excel to
fill in the ":" for me. I thought I could define/format certain cells so that
this would work, but I haven't been able to do so. If this should be
possible, please let me know! Thanks.

 

[Josh Bertsch [MSFT]]

If you have a suggestion for Excel, it would receive better attention in
that particular newsgroup.

--josh bertsch