Time Duration Quarry

1183
2
Jump to solution
05-04-2016 07:20 AM
AzaN
by
New Contributor III

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

0 Kudos
1 Solution

Accepted Solutions
DanPatterson_Retired
MVP Emeritus

In excel you need to format the columns as time with and without the AM/PM designator

Excel_time_diff.png

View solution in original post

2 Replies
DanPatterson_Retired
MVP Emeritus

In excel you need to format the columns as time with and without the AM/PM designator

Excel_time_diff.png

AzaN
by
New Contributor III

Thanks Dan. Yes, I had to work on the Excel file and export it to ArcGIS again.

0 Kudos