Formatting Times In Excel
 

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.

Formatting Times In Excel
 

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.

Formatting Times In Excel
 

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)



"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.