topic Time Duration Quarry in Training in GIS Questions https://community.esri.com/t5/training-in-gis-questions/time-duration-quarry/m-p/836838#M45 <HTML><HEAD></HEAD><BODY><P>Hi Everyone.</P><P>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.</P><P></P><P>Thanks in advance,</P><P>Azadeh</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/198159_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 04 May 2016 14:20:53 GMT AzaN 2016-05-04T14:20:53Z Time Duration Quarry https://community.esri.com/t5/training-in-gis-questions/time-duration-quarry/m-p/836838#M45 <HTML><HEAD></HEAD><BODY><P>Hi Everyone.</P><P>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.</P><P></P><P>Thanks in advance,</P><P>Azadeh</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/198159_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 04 May 2016 14:20:53 GMT https://community.esri.com/t5/training-in-gis-questions/time-duration-quarry/m-p/836838#M45 AzaN 2016-05-04T14:20:53Z Re: Time Duration Quarry https://community.esri.com/t5/training-in-gis-questions/time-duration-quarry/m-p/836839#M46 <HTML><HEAD></HEAD><BODY><P>In excel you need to format the columns as time with and without the AM/PM designator</P><P><IMG alt="Excel_time_diff.png" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/198173_Excel_time_diff.png" style="height: auto;" /></P></BODY></HTML> Wed, 04 May 2016 14:41:37 GMT https://community.esri.com/t5/training-in-gis-questions/time-duration-quarry/m-p/836839#M46 DanPatterson_Retired 2016-05-04T14:41:37Z Re: Time Duration Quarry https://community.esri.com/t5/training-in-gis-questions/time-duration-quarry/m-p/836840#M47 <HTML><HEAD></HEAD><BODY><P>Thanks Dan. Yes, I had to work on the Excel file and export it to ArcGIS again.</P></BODY></HTML> Wed, 04 May 2016 14:47:48 GMT https://community.esri.com/t5/training-in-gis-questions/time-duration-quarry/m-p/836840#M47 AzaN 2016-05-04T14:47:48Z