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