All:
rbase 9.1_(64) 9.1.5.20510
Windows 7
MS Excel 2003
My experience importing dates and times from Excel is spotty. For instance, times defined in Excel as '13:30' don't import at all.
Does anyone have any dead-bang-always-work Excel formats for date and time columns?
The target columns are appropriately defined with DATE or TIME data types.
I'm using the RBase defaults for date and time formats:
Date:
Format: MM/DD/YYYY
Sequence: MMDDYY
Year: 30
Century: 19
Time:
Format: HH:MM
Sequence: HHMM
TIA
Bruce
