topic Re: Excel/CSV_Timefield format to shp in Data Management Questions https://community.esri.com/t5/data-management-questions/excel-csv-timefield-format-to-shp/m-p/119888#M6848 <HTML><HEAD></HEAD><BODY><P>shapefiles have to have the dates separated in to two component fields (date and time).&nbsp; If you want them in one field, then use a featureclass or table in a file geodatabase.</P></BODY></HTML> Sun, 28 Feb 2016 14:44:29 GMT DanPatterson_Retired 2016-02-28T14:44:29Z Excel/CSV_Timefield format to shp https://community.esri.com/t5/data-management-questions/excel-csv-timefield-format-to-shp/m-p/119887#M6847 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P>I have problems with converting CSV file to arcgis table. I have field name <STRONG>"TS1"</STRONG> and <STRONG>"TS2"</STRONG> both of&nbsp; fields represents time in hours: minutes: seconds (format).</P><P>I would like&nbsp; to convert this file Arcgis table en finaly&nbsp; ended up as arcgis table. En after that i can read it as point shape file.</P><P>I think there was a problem with the format of these two fields that I ended up in the converted fields as 00:00:00. How these two fields after converting the same value as give the csv file.</P><P>That i finally can calculate the time differences and comes out on the field<STRONG> "TS3"</STRONG></P><P>Please see the attachment i sent,&nbsp; the CSV file.&nbsp; Hopefully that somebody can help me to solve this problem.</P><P>Best regards,</P><P>John Rumambi</P></BODY></HTML> Sun, 28 Feb 2016 13:02:32 GMT https://community.esri.com/t5/data-management-questions/excel-csv-timefield-format-to-shp/m-p/119887#M6847 JohnRumambi 2016-02-28T13:02:32Z Re: Excel/CSV_Timefield format to shp https://community.esri.com/t5/data-management-questions/excel-csv-timefield-format-to-shp/m-p/119888#M6848 <HTML><HEAD></HEAD><BODY><P>shapefiles have to have the dates separated in to two component fields (date and time).&nbsp; If you want them in one field, then use a featureclass or table in a file geodatabase.</P></BODY></HTML> Sun, 28 Feb 2016 14:44:29 GMT https://community.esri.com/t5/data-management-questions/excel-csv-timefield-format-to-shp/m-p/119888#M6848 DanPatterson_Retired 2016-02-28T14:44:29Z