Spreadsheet: 266232d1379534872-how-to-get-earliest-time-in-and-latest-time-out-sample1
Sheet: Raw

Name | Date | [NAME] | Logout Date | Logout Time
Abalos, [NAME] | 2013-09-09 00:00:00 | 06:00:00 | 2013-09-09 00:00:00 | 15:01:00
Batu, Ruvel | 2013-09-09 00:00:00 | 22:00:00 | 2013-09-10 00:00:00 | 07:00:00
Bayas, [NAME] | 2013-09-09 00:00:00 | 18:59:00 | 2013-09-10 00:00:00 | 04:10:00
[NAME], [NAME] | 2013-09-09 00:00:00 | 04:00:00 | 2013-09-09 00:00:00 | 13:00:00
Cabalu, Preciosa | 2013-09-09 00:00:00 | 22:00:00 | 2013-09-10 00:00:00 | 07:00:00
Castillo, [NAME] | 2013-09-09 00:00:00 | 20:00:00 | 2013-09-09 00:00:00 | 20:00:00
Castillo, [NAME] | 2013-09-09 00:00:00 | 20:05:00 | 2013-09-09 00:00:00 | 20:05:00
Castillo, [NAME] | 2013-09-09 00:00:00 | 20:05:00 | 2013-09-09 00:00:00 | 21:19:00
Castillo, [NAME] | 2013-09-09 00:00:00 | 21:20:00 | 2013-09-09 00:00:00 | 21:27:00
Castillo, [NAME] | 2013-09-09 00:00:00 | 21:28:00 | 2013-09-10 00:00:00 | 05:00:00
Chunaco, Perseus | 2013-09-09 00:00:00 | 22:00:00 | 2013-09-10 00:00:00 | 07:01:00
Daguio, [NAME] | 2013-09-09 00:00:00 | 15:54:00 | 2013-09-10 00:00:00 | 01:02:00
Dalanon, Blanche | 2013-09-09 00:00:00 | 19:00:00 | 2013-09-10 00:00:00 | 04:13:00
[NAME], [NAME] | 2013-09-09 00:00:00 | 20:58:00 | 2013-09-10 00:00:00 | 06:00:00
[NAME], [NAME] | 2013-09-09 00:00:00 | 20:53:00 | 2013-09-10 00:00:00 | 05:01:00
[NAME], Terence | 2013-09-09 00:00:00 | 09:11:00 | 2013-09-09 00:00:00 | 09:11:00
[NAME], Terence | 2013-09-09 00:00:00 | 09:11:00 | 2013-09-09 00:00:00 | 13:00:00
Galang, [NAME] | 2013-09-09 00:00:00 | 14:59:00 | 2013-09-09 00:00:00 | 14:59:00
Galang, [NAME] | 2013-09-09 00:00:00 | 15:03:00 | 2013-09-09 00:00:00 | 21:35:00
Galang, [NAME] | 2013-09-09 00:00:00 | 21:37:00 | 2013-09-09 00:00:00 | 23:38:00
Galang, [NAME] | 2013-09-09 00:00:00 | 23:39:00 | 2013-09-10 00:00:00 | 01:18:00
Godornes, Dominic | 2013-09-09 00:00:00 | 22:00:00 | 2013-09-09 00:00:00 | 22:00:00
Godornes, Dominic | 2013-09-09 00:00:00 | 22:01:00 | 2013-09-10 00:00:00 | 08:23:00
[NAME], [NAME] | 2013-09-09 00:00:00 | 05:57:00 | 2013-09-09 00:00:00 | 15:01:00
Lising, [NAME] | 2013-09-09 00:00:00 | 17:59:00 | 2013-09-10 00:00:00 | 03:00:00
[NAME], Alejandro Jos | 2013-09-09 00:00:00 | 19:54:00 | 2013-09-10 00:00:00 | 05:01:00
Lopez, Lance | 2013-09-09 00:00:00 | 18:59:00 | 2013-09-10 00:00:00 | 04:02:00
Malayao, [NAME] | 2013-09-09 00:00:00 | 20:00:00 | 2013-09-10 00:00:00 | 05:00:00
Mateo, [NAME] | 2013-09-09 00:00:00 | 20:59:00 | 2013-09-10 00:00:00 | 06:05:00
Mendoza, [NAME] | 2013-09-09 00:00:00 | 20:11:00 | 2013-09-10 00:00:00 | 03:02:00
[NAME], [NAME] | 2013-09-09 00:00:00 | 22:00:00 | 2013-09-10 00:00:00 | 07:04:00
Morales, [NAME] | 2013-09-09 00:00:00 | 06:41:00 | 2013-09-09 00:00:00 | 06:41:00
Morales, [NAME] | 2013-09-09 00:00:00 | 07:04:00 | 2013-09-09 00:00:00 | 13:00:00
Narcelles, [NAME] | 2013-09-09 00:00:00 | 09:01:00 | 2013-09-09 00:00:00 | 18:01:00
Nepomuceno, Ricardo | 2013-09-09 00:00:00 | 22:00:00 | 2013-09-10 00:00:00 | 07:06:00
[NAME], [NAME] | 2013-09-09 00:00:00 | 14:54:00 | 2013-09-09 00:00:00 | 14:56:00
[NAME], [NAME] | 2013-09-09 00:00:00 | 14:59:00 | 2013-09-09 00:00:00 | 17:09:00
[NAME], [NAME] | 2013-09-09 00:00:00 | 17:09:00 | 2013-09-09 00:00:00 | 20:36:00
Paladin, [NAME] | 2013-09-09 00:00:00 | 22:00:00 | 2013-09-10 00:00:00 | 07:00:00
Pamintuan, [NAME] | 2013-09-09 00:00:00 | 19:59:00 | 2013-09-10 00:00:00 | 05:01:00
Panganiban, Rominda | 2013-09-09 00:00:00 | 18:59:00 | 2013-09-09 00:00:00 | 20:37:00
Panganiban, Rominda | 2013-09-09 00:00:00 | 20:41:00 | 2013-09-10 00:00:00 | 04:00:00
Pangilinan, Alfredo | 2013-09-09 00:00:00 | 19:59:00 | 2013-09-10 00:00:00 | 05:00:00
Payot, [NAME] | 2013-09-09 00:00:00 | 21:59:00 | 2013-09-10 00:00:00 | 07:01:00
Pe¤afiel, [NAME] | 2013-09-09 00:00:00 | 21:08:00 | 2013-09-10 00:00:00 | 06:24:00
Pineda, [NAME] | 2013-09-09 00:00:00 | 13:07:00 | 2013-09-09 00:00:00 | 19:31:00
Pineda, [NAME] | 2013-09-09 00:00:00 | 19:31:00 | 2013-09-09 00:00:00 | 21:06:00
Ramos, [NAME] | 2013-09-09 00:00:00 | 20:59:00 | 2013-09-10 00:00:00 | 06:00:00
[NAME], [NAME] | 2013-09-09 00:00:00 | 19:59:00 | 2013-09-10 00:00:00 | 05:00:00
Sabdao, Loreta | 2013-09-09 00:00:00 | 21:00:00 | 2013-09-10 00:00:00 | 06:15:00
Salazar, Alexis | 2013-09-09 00:00:00 | 18:59:00 | 2013-09-10 00:00:00 | 04:00:00
Santillana, Jaycee | 2013-09-09 00:00:00 | 20:59:00 | 2013-09-10 00:00:00 | 06:00:00
Sarmiento, [NAME] | 2013-09-09 00:00:00 | 05:00:00 | 2013-09-09 00:00:00 | 14:00:00
Schwartz, [NAME] | 2013-09-09 00:00:00 | 19:54:00 | 2013-09-10 00:00:00 | 05:00:00
Sichongco, [NAME] | 2013-09-09 00:00:00 | 19:29:00 | 2013-09-10 00:00:00 | 04:00:00
[NAME], Ruel | 2013-09-09 00:00:00 | 22:00:00 | 2013-09-10 00:00:00 | 07:02:00
Ta¤ada, Cristina | 2013-09-09 00:00:00 | 18:57:00 | 2013-09-10 00:00:00 | 16:14:00
Taneo, Anabelle | 2013-09-09 00:00:00 | 20:00:00 | 2013-09-10 00:00:00 | 05:19:00
Tanuan, [NAME] | 2013-09-09 00:00:00 | 17:59:00 | 2013-09-10 00:00:00 | 03:00:00
[NAME], [NAME] | 2013-09-09 00:00:00 | 18:00:00 | 2013-09-10 00:00:00 | 03:00:00