You don't have to write the macro.

Chip has done that for you.


Gord Dibben MS Excel MVP

On Wed, 29 Jul 2009 05:44:01 -0700, Hezzy
wrote:

If I understand this right I have to write a macro to the the time to display
the way I want? i.e. 8 = 8:00?

"JE McGimpsey" wrote:

see

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

In article ,
JarvisC wrote:

How can i format a cell that will display the ime as 08:00 when i enter 8? i
have tried using the format hh:mm but when i enter 8 the cell displays
00:00:00 and the formula bar shows 08/01/1900 00:00:00.