PanMusic,

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

HTH,
Bernie
MS Excel MVP


"panmusic" wrote in message
...
I currently use Office 2003. Is there a format i can set up for cells where i
can type in just 4 characters for a time, say 0845 for 8:45 AM without having
to type in the : colon or the "AM". I have set up formats for numbers
generally, but can't seem to get this working. I have a column for AM times,
and another for PM times, so there could be two formats, one for each column.
Please help.