I am trying to import a file from Excel which is a GPS data set of consecutive points at 15minute intervals. When I import the file and save it as a shape file the time column is not read properly and GIS converts to 00:00:00 and then further down the column shifts to 01/01/1900. I have tried to format the column in Excel as either hh:mm, hh:mm:ss, dd/mm/yyyy hh:mm or no number format and each has the same end result. The imported table shows the correct times but as soon as the data table is converted to a shape file to be displayed the time format is lost. I have never noticeably had this problem when importing data previously and I did not need to format the time. Now it seems that no formatting method will work properly.
How can I format the time column to retain the time values when imported and saved as a shape file?
Thanks for your help.
أكثر...
How can I format the time column to retain the time values when imported and saved as a shape file?
Thanks for your help.
أكثر...