Spreadsheet: 817575d1676327490-help-with-calculating-time-difference-using-two-criteria-fields-spreadsheet-for-help
Sheet: Sample data for help

Create Date | Create Time | Event # | Event ESZ | [NAME] | Unit ID | Type Code | Unit Status | Unit Status Date/Time | Status Type | Status Time
2021-09-01 00:00:00 | 2021-09-01 01:39:10 | E2156684 | 6144022 | 344 | 344-5 | MPA | Dispatched | 09/01/2021 01:39:20 | 2021-09-01 00:00:00 | 01:39:20
2021-09-01 00:00:00 | 2021-09-01 01:39:10 | E2156684 | 6144022 | 344 | 344-5 | MPA | Enroute | 09/01/2021 01:42:29 | 2021-09-01 00:00:00 | 01:42:29
2021-09-01 00:00:00 | 2021-09-01 01:39:10 | E2156684 | 6144022 | 344 | 344-5 | MPA | Arrived | 09/01/2021 01:46:24 | 2021-09-01 00:00:00 | 01:46:24
2021-09-01 00:00:00 | 2021-09-01 01:39:10 | E2156684 | 6144022 | 344 | 344-5 | MPA | Available | 09/01/2021 01:53:44 | 2021-09-01 00:00:00 | 01:53:44
2021-09-01 00:00:00 | 2021-09-01 02:13:18 | E2156688 | 6144025 | 344 | 344-5 | MFV | Dispatched | 09/01/2021 02:13:37 | 2021-09-01 00:00:00 | 02:13:37
2021-09-01 00:00:00 | 2021-09-01 02:13:18 | E2156688 | 6144025 | 344 | 344-5 | MFV | Enroute | 09/01/2021 02:15:39 | 2021-09-01 00:00:00 | 02:15:39
2021-09-01 00:00:00 | 2021-09-01 02:13:18 | E2156688 | 6144025 | 344 | 344-5 | MFV | Arrived | 09/01/2021 02:18:43 | 2021-09-01 00:00:00 | 02:18:43
2021-09-01 00:00:00 | 2021-09-01 02:13:18 | E2156688 | 6144025 | 344 | 344-5 | MFV | Available | 09/01/2021 02:28:17 | 2021-09-01 00:00:00 | 02:28:17
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | 344-11 | MSE | Dispatched | 09/01/2021 08:07:32 | 2021-09-01 00:00:00 | 08:07:32
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | QX71 | MSE | Dispatched | 09/01/2021 08:07:32 | 2021-09-01 00:00:00 | 08:07:32
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | QX71 | MSE | Available | 09/01/2021 08:08:08 | 2021-09-01 00:00:00 | 08:08:08
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | 344-11 | MSE | Enroute | 09/01/2021 08:09:13 | 2021-09-01 00:00:00 | 08:09:13
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | 344-11 | MSE | Arrived | 09/01/2021 08:13:33 | 2021-09-01 00:00:00 | 08:13:33
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | 344-5 | MSE | Dispatched | 09/01/2021 [NAME] | 2021-09-01 00:00:00 | 08:16:51
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | 344-5 | MSE | Enroute | 09/01/2021 08:16:52 | 2021-09-01 00:00:00 | 08:16:52
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | 344-5 | MSE | Arrived | 09/01/2021 08:23:33 | 2021-09-01 00:00:00 | 08:23:33
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | 344-11 | MSE | Transport | 09/01/2021 08:31:31 | 2021-09-01 00:00:00 | 08:31:31
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | 344-5 | MSE | Transport | 09/01/2021 [NAME] | 2021-09-01 00:00:00 | 08:31:38
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | 344-5 | MSE | Transport Arrive | 09/01/2021 08:49:26 | 2021-09-01 00:00:00 | 08:49:26
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | 344-11 | MSE | Transport Arrive | 09/01/2021 08:49:51 | 2021-09-01 00:00:00 | 08:49:51
2021-09-01 00:00:00 | 2021-09-01 08:07:21 | E2156719 | 7944113 | 344A | 344-5 | MSE | Available | 09/01/2021 09:21:18 | 2021-09-01 00:00:00 | 09:21:18
Custom Short Date | Custom Full Date | Text | Number | Text | Text | Text | Text | Text | Date | Custom (Time)