Spreadsheet: 108687d1305704609-earliest-and-late-first-and-last-records-first-and-last-record-using-adv-filtering-
Sheet: Sheet1

Sequence | Date and Time | Date | Time | Date + Time | Event message | Event number | Object #1 | Description #1 | Object #2 | Description #2 | Object #3 | Description #3 | Object #4 | Description #4 | Card number
1 | 3/1/2011 8:54:04 AM | 2011-03-01 00:00:00 | 08:54:04 | 2011-03-01 08:54:04 | Access - door opened | 201 | 12 | Main Door In | 5 | [NAME] | 0 |  | 0
2 | 3/1/2011 2:02:20 PM | 2011-03-01 00:00:00 | 14:02:20 | 2011-03-01 14:02:20 | Access granted | 203 | 12 | Main Door Out | 5 | [NAME] | 0 |  | 0
3 | 3/1/2011 6:23:32 PM | 2011-03-01 00:00:00 | 18:23:32 | 2011-03-01 18:23:32 | Access granted | 203 | 12 | Main Door Out | 5 | [NAME] | 0 |  | 0
4 | 3/1/2011 6:29:00 PM | 2011-03-01 00:00:00 | 18:29:00 | 2011-03-01 18:29:00 | Access granted | 203 | 12 | Main Door In | 5 | [NAME] | 0 |  | 0
5 | 3/1/2011 8:29:04 PM | 2011-03-01 00:00:00 | 20:29:04 | 2011-03-01 20:29:04 | Access - door opened | 201 | 12 | Main Door Out | 5 | [NAME] | 0 |  | 0
6 | 3/1/2011 8:52:48 AM | 2011-03-01 00:00:00 | 08:52:48 | 2011-03-01 08:52:48 | Access granted | 203 | 12 | Main Door In | 5 | Ailson Gi | 0 |  | 0
7 | 3/1/2011 12:25:44 PM | 2011-03-01 00:00:00 | 12:25:44 | 2011-03-01 12:25:44 | Access granted | 203 | 12 | Main Door Out | 5 | Ailson Gi | 0 |  | 0
8 | 3/1/2011 1:02:20 PM | 2011-03-01 00:00:00 | 13:02:20 | 2011-03-01 13:02:20 | Access granted | 203 | 12 | Main Door In | 5 | Ailson Gi | 0 |  | 0
9 | 3/1/2011 7:28:56 PM | 2011-03-01 00:00:00 | 19:28:56 | 2011-03-01 19:28:56 | Access granted | 203 | 12 | Main Door Out | 5 | Ailson Gi | 0 |  | 0
10 | 3/18/2011 8:52:12 AM | 2011-03-18 00:00:00 | 08:52:12 | 2011-03-18 08:52:12 | Access granted | 203 | 12 | Main Door In | 5 | [NAME] | 0 |  | 0
11 | 3/18/2011 12:26:08 PM | 2011-03-18 00:00:00 | 12:26:08 | 2011-03-18 12:26:08 | Access granted | 203 | 12 | Main Door Out | 5 | [NAME] | 0 |  | 0
12 | 3/18/2011 1:08:52 PM | 2011-03-18 00:00:00 | 13:08:52 | 2011-03-18 13:08:52 | Access granted | 203 | 12 | Main Door In | 5 | [NAME] | 0 |  | 0
13 | 3/18/2011 7:28:24 PM | 2011-03-18 00:00:00 | 19:28:24 | 2011-03-18 19:28:24 | Access granted | 203 | 12 | Main Door Out | 5 | [NAME] | 0 |  | 0
14 | 3/18/2011 8:51:16 AM | 2011-03-18 00:00:00 | 08:51:16 | 2011-03-18 08:51:16 | Access granted | 203 | 12 | Main Door In | 5 | [NAME] | 0 |  | 0
15 | 3/18/2011 12:26:56 PM | 2011-03-18 00:00:00 | 12:26:56 | 2011-03-18 12:26:56 | Access granted | 203 | 12 | Main Door Out | 5 | [NAME] | 0 |  | 0
16 | 3/18/2011 12:27:48 PM | 2011-03-18 00:00:00 | 12:27:48 | 2011-03-18 12:27:48 | Access granted | 203 | 12 | Main Door In | 5 | [NAME] | 0 |  | 0
17 | 3/18/2011 12:28:04 PM | 2011-03-18 00:00:00 | 12:28:04 | 2011-03-18 12:28:04 | Access granted | 203 | 12 | Main Door Out | 5 | [NAME] | 0 |  | 0
18 | 3/18/2011 1:07:12 PM | 2011-03-18 00:00:00 | 13:07:12 | 2011-03-18 13:07:12 | Access granted | 203 | 12 | Main Door In | 5 | [NAME] | 0 |  | 0
19 | 3/18/2011 6:28:12 PM | 2011-03-18 00:00:00 | 18:28:12 | 2011-03-18 18:28:12 | Access - door opened | 201 | 12 | Main Door Out | 5 | [NAME] | 0 |  | 0
Sequence | Date and Time | Date | Time | Date + Time | Event message | Event number | Object #1 | Description #1 | Object #2 | Description #2 | Object #3 | Description #3 | Object #4 | Description #4 | Card number
 |  | 2011-03-01 00:00:00 |  | max(e1:e19) |  |  |  |  |  | [NAME]
 |  | 2011-03-01 00:00:00 |  | min(e1:e19) |  |  |  |  |  | [NAME]
 |  | 2011-03-18 00:00:00 |  | max(e1:e19) |  |  |  |  |  | [NAME]
 |  | 2011-03-18 00:00:00 |  | min(e1:e19) |  |  |  |  |  | [NAME]
1 | 3/1/2011 8:54:04 AM | 2011-03-01 00:00:00 | 08:54:04 | 2011-03-01 08:54:04 | Access - door opened | 201 | 12 | Main Door In | 5 | [NAME] | 0 |  | 0
5 | 3/1/2011 8:29:04 PM | 2011-03-01 00:00:00 | 20:29:04 | 2011-03-01 20:29:04 | Access - door opened | 201 | 12 | Main Door Out | 5 | [NAME] | 0 |  | 0
14 | 3/18/2011 8:51:16 AM | 2011-03-18 00:00:00 | 08:51:16 | 2011-03-18 08:51:16 | Access granted | 203 | 12 | Main Door In | 5 | [NAME] | 0 |  | 0
19 | 2011-03-18 18:28:12 | 2011-03-18 00:00:00 | 18:28:12 | 2011-03-18 18:28:12 | Access - door opened | 201 | 12 | Main Door Out | 5 | [NAME] | 0 |  | 0