Time Formating

Denise · Nov 20, 2003

I need to know how to format a cell for time. I need to have the cell formatted so that when I type in the cell say 125211 or 12 52 11 it will automatically appear as 12:52:11.

Peo Sjoblom · Nov 20, 2003

For a possible solution see

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

--

Regards,

Peo Sjoblom

Denise said:
I need to know how to format a cell for time. I need to have the cell

formatted so that when I type in the cell say 125211 or 12 52 11 it will
automatically appear as 12:52:11.