Strange behavior.
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
|