Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change the default paste behavior | Excel Discussion (Misc queries) | |||
Strange Personal Macro Workbook Behavior | Excel Discussion (Misc queries) | |||
Strange Excel problem when opening an Excelbook | Excel Discussion (Misc queries) | |||
Strange behavior w/ Text, Button, & Check Boxes | Excel Discussion (Misc queries) | |||
Baffling Sum/Average Behavior | Excel Discussion (Misc queries) |