AnsweredAssumed Answered

Excel/CSV_Timefield format to shp

Question asked by JohnRumambi on Feb 28, 2016
Latest reply on Feb 28, 2016 by Dan_Patterson

Hello everyone,

I have problems with converting CSV file to arcgis table. I have field name "TS1" and "TS2" both of  fields represents time in hours: minutes: seconds (format).

I would like  to convert this file Arcgis table en finaly  ended up as arcgis table. En after that i can read it as point shape file.

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.

That i finally can calculate the time differences and comes out on the field "TS3"

Please see the attachment i sent,  the CSV file.  Hopefully that somebody can help me to solve this problem.

Best regards,

John Rumambi