Brian

See Chip Peason's site for date/time "quick entry" methods.

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


Gord Dibben Excel MVP

On Sun, 18 Dec 2005 12:00:22 -0600, Brian Handly wrote:

I have a time sheet with Start and Stop times. I want to enter 22:00 as
"2200". However, EXCEL does not recognize "2200" as a time. How can I
force it to recognize it as a time or how can I convert it to a time?

Texas Handly