Hi Everyone.
I am working on an incident dataset (as shown below), and trying to run a quarry in Select by Attributes. I need to select the incidents (point shapefile) that have lasted more than 15 minutes. Is there any way that I can do it here in ArcGIS? If not, the original dataset was in Excel format. You have any idea about that? I have tried to deduct the Time-opened column from Time-Closed, but the result for all is 0.
Thanks in advance,
Azadeh
Solved! Go to Solution.
In excel you need to format the columns as time with and without the AM/PM designator
In excel you need to format the columns as time with and without the AM/PM designator
Thanks Dan. Yes, I had to work on the Excel file and export it to ArcGIS again.