Excel/CSV_Timefield format to shp

1581
1
Jump to solution
02-28-2016 05:02 AM
Highlighted
New Contributor

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

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
MVP Esteemed Contributor

shapefiles have to have the dates separated in to two component fields (date and time).  If you want them in one field, then use a featureclass or table in a file geodatabase.

View solution in original post

1 Reply
Highlighted
MVP Esteemed Contributor

shapefiles have to have the dates separated in to two component fields (date and time).  If you want them in one field, then use a featureclass or table in a file geodatabase.

View solution in original post