I have a time field in my shapefile that is formatted as HH:mm:ss.s It is a text field, and I want to convert it to a date so I can calculate time elapsed across rows (if there's a better way to do this let me know). Basically, each row is a point on a route, and I want to use the time field to calculate the amount of time elapsed between the first and last points on the route.
I tried using the convert time field tool, setting the input format as HH:mm:ss.s, and the output type as DATE. The output field however only shows values of 01/01/2001 for some rows and for other rows.
time is the input field and time_c is the output field
I'm not sure what's going wrong here, here is what shows up in the geoprocessing results window:
Any help would be greatly appreciated, thanks!
أكثر...
I tried using the convert time field tool, setting the input format as HH:mm:ss.s, and the output type as DATE. The output field however only shows values of 01/01/2001 for some rows and for other rows.
time is the input field and time_c is the output field
I'm not sure what's going wrong here, here is what shows up in the geoprocessing results window:
Any help would be greatly appreciated, thanks!
أكثر...