I am retrieving a field which is stored in a backend Oracle database as a 5 figure 'general' time field .I've tried reformatting in the query, and also reformatting the field after retrieval, but I can't get Excel to understand it.
The application database displays the field as 'hh:mm'.
Ultimately, I want to concatenate this field with a corresponding date field, to use the exact time/date, to query for only the stuff I haven't already processed. The date field was 'date/time' and excel had no problems with it .
Unlike Excel, the serial number in the Oracle time field is a whole number.
Has anyone else come across this problem ?
The application database displays the field as 'hh:mm'.
Ultimately, I want to concatenate this field with a corresponding date field, to use the exact time/date, to query for only the stuff I haven't already processed. The date field was 'date/time' and excel had no problems with it .
Unlike Excel, the serial number in the Oracle time field is a whole number.
Has anyone else come across this problem ?