chiefb22enator
New Member
- Joined
- Jan 28, 2019
- Messages
- 3
I'm trying to determine which fire vehicle arrived first at the scene of an incident (and there are thousands of them). Each incident has a unique incident number, and has one or more apparatus that are dispatched on the call. The arrival times for each unit are logged. But, I need a formula that compares the arrival date/time for each incident and determines who arrived first on each incident so I can sort and analyze further. Here's an example of the data I'm using:
IncNumber | Incident Count | IncType | IncDesc | Station | AppID | ArvDate | ArvTime |
2019-0000045 | 0 | 142 | Brush, or brush and grass mixture fire | ST5 | B3 | 1/1/2019 | 3:43:06 |
2019-0000045 | 1 | 142 | Brush, or brush and grass mixture fire | ST5 | ME5 | 1/1/2019 | 3:40:06 |
2019-0001151 | 0 | 142 | Brush, or brush and grass mixture fire | ST2 | B1 | 1/5/2019 | 4:16:36 |
2019-0001151 | 0 | 142 | Brush, or brush and grass mixture fire | ST2 | B61 | 1/5/2019 | 4:21:16 |
2019-0001151 | 0 | 142 | Brush, or brush and grass mixture fire | ST2 | ME2 | 1/5/2019 | 4:17:04 |
2019-0001151 | 1 | 142 | Brush, or brush and grass mixture fire | ST2 | ME3 | 1/5/2019 | 4:15:54 |
2019-0001151 | 0 | 142 | Brush, or brush and grass mixture fire | ST2 | ME4 | 1/5/2019 | 4:19:09 |
2019-0001151 | 0 | 142 | Brush, or brush and grass mixture fire | ST2 | ME5 | 1/5/2019 | 4:17:12 |
2019-0003281 | 1 | 111A | Building fire - Confined to Area Involved on Arrival | ST1 | MRE23 | 1/12/2019 | 19:04:05 |
2019-0004610 | 1 | 111A | Building fire - Confined to Area Involved on Arrival | ST3 | ME4 | 1/17/2019 | 16:19:46 |
2019-0004610 | 0 | 111A | Building fire - Confined to Area Involved on Arrival | ST3 | ME7 | 1/17/2019 | 16:18:46 |
2019-0006317 | 0 | 111A | Building fire - Confined to Area Involved on Arrival | ST5 | B2 | 1/23/2019 | 22:31:37 |
2019-0006317 | 1 | 111A | Building fire - Confined to Area Involved on Arrival | ST5 | ME102 | 1/23/2019 | 22:29:20 |
2019-0006317 | 0 | 111A | Building fire - Confined to Area Involved on Arrival | ST5 | ME2 | 1/23/2019 | 22:33:09 |
2019-0006317 | 0 | 111A | Building fire - Confined to Area Involved on Arrival | ST5 | ME3 | 1/23/2019 | 22:31:23 |
2019-0006317 | 0 | 111A | Building fire - Confined to Area Involved on Arrival | ST5 | ME4 | 1/23/2019 | 22:32:53 |
2019-0006317 | 0 | 111A | Building fire - Confined to Area Involved on Arrival | ST5 | MT5 | 1/23/2019 | 22:30:12 |
2019-0006324 | 1 | 111A | Building fire - Confined to Area Involved on Arrival | ST1 | ME1 | 1/23/2019 | 22:51:12 |