cell assumes wrong date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

julie from Seattle - 30 Nov 2004 19:05 GMT

I want to format a cell for time. I want to type "0830" in a cell and have it
show 8:30 AM. So I format the cell accordingly. But when I type 0830 in the
cell I get "12:00 AM", and if I double click into the cell it shows "4/9/1902
12:00:00 AM". What can I do to have it not include a date...just a time?

Reply to this Message

Peo Sjoblom - 30 Nov 2004 19:51 GMT

You can't unless you use a macro, see:

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

One day is 1, one hour is 1/24 no formatting can change 830x24 hours into
08:30, you need the above macro

Regards,

Peo Sjoblom

> I want to format a cell for time. I want to type "0830" in a cell and have it
> show 8:30 AM. So I format the cell accordingly. But when I type 0830 in the
> cell I get "12:00 AM", and if I double click into the cell it shows "4/9/1902
> 12:00:00 AM". What can I do to have it not include a date...just a time?

Reply to this Message

Rate this thread: