excel time format

[JarvisC]

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.

[JE McGimpsey]

see

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

In article <[email protected]>,
JarvisC <[email protected]> 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.

[JarvisC]

Many thanks, works a treat!

"JE McGimpsey" wrote:

> see
>
> http://cpearson.com/excel/DateTimeEntry.htm
>
> In article <[email protected]>,
> JarvisC <[email protected]> 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.
>