View Single Post
  #1   Report Post  
Wiley Coyote
 
Posts: n/a
Default 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