If I format a cell as General and then type 22:00 into that cell, excel will
format the cell as Custom hh:mm.

If you type: 22:00 in the cell, then format the cell as general, what do you
see?

Just a guess...

Have you been playing in the windows regional settings--maybe the time or number
tab??

Wiley Coyote wrote:

Hey thatnks Dave. But the cell shows 12:00 AM (both of them) the Formula Bar
shows 9/26/1902 12:00:00 AM. I tried to format the cells as general and
enter (for example) 22:00 and it displays correctly, however I cannot
perform calculations on the cell (without converting to date/time).

As mentioned in my original post, this worked fine up til about a week or so
ago and Nothing has changed in the sheet.

TX.
"Dave Peterson" wrote in message
...
If you format that cell that shows 9/26/1902 as General, you'll see that
the
value in the cell is 1000.

That looks suspicious to me.

I'd try just retyping 10:00



Wiley Coyote wrote:

I have an Excel (Off2K3) spreadsheet that I've been using to track time
for
quite some time. I have two columns, Time In and Time Out. The columns
are
formatted as TIME as 13:30 for example.

When I now enter Time (example Time In) as 10:00 and Time Out as 22:00,
both
columns display 0:00 and 9/26/1902 12:00:00 AM is displayed in the
formula
bar.

Any ideas???

Wiley

--

Dave Peterson

--

Dave Peterson