Formatting Times In Excel

[Guest]

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.

 

[Bernie Deitrick]

PanMusic,

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

HTH,
Bernie
MS Excel MVP

 

[Bob Phillips]

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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)