Spreadsheet: 329961d1404468132-using-index-match-with-multiple-criteria-in-and-out
Sheet: Daily

 |  |  |  | In1 | Out1 |  | In2 | Out2 | In3 |  | Out3 |  | In4 | Out4 | In5 |  | Out5 | In6 | Out6 | In7 | Out7 | In8 | Out8
Log Date | 2014-07-01 00:00:00
Emp Code | Emp Name |  | Deparment | Log Records |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Status
1 | Satheesh P |  | 2014-07-01 00:00:00 | 09:26 | 13:28 |  | 13:47 | 20:10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
2 | [NAME] |  | 2014-07-01 00:00:00 | 13:39 | 22:02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
3 | Ranjith Prasanth C |  | 2014-07-01 00:00:00 | 06:13 | 16:13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
4 | [NAME] |  | 2014-07-01 00:00:00
5 | Harisankaran K S |  | 2014-07-01 00:00:00 | 09:33 | 19:12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
6 | [NAME] |  | 2014-07-01 00:00:00
7 | Yuvraj N |  | 2014-07-01 00:00:00 | 08:58 | 13:15 |  | 13:25 | 17:21 | 17:29 |  | 18:51 |  |  |  |  |  |  |  |  |  |  |  |  | P
8 | Kannan P |  | 2014-07-01 00:00:00
9 | Vijay V |  | 2014-07-01 00:00:00 | 01:39 | 11:34 |  | 13:16 | 13:33 | 16:11 |  | 16:37 |  | 18:34 |  |  |  |  |  |  |  |  |  |  | P
10 | [NAME]. M |  | 2014-07-01 00:00:00 | 13:59 | 19:01 |  | 19:11 | 22:03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
Log Date | 02 Jul 2014
Emp Code | Emp Name |  | Deparment | Log Records |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Status
1 | Satheesh P |  | 2014-07-02 00:00:00 | 09:32 | 13:28 |  | 13:48 | 19:28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
2 | [NAME] |  | 2014-07-02 00:00:00 | 13:45 | 22:03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
3 | Ranjith Prasanth C |  | 2014-07-02 00:00:00 | 06:25 | 07:54 |  | 08:36 | 14:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
4 | [NAME] |  | 2014-07-02 00:00:00
5 | Harisankaran K S |  | 2014-07-02 00:00:00 | 09:38 | 21:12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
6 | [NAME] |  | 2014-07-02 00:00:00
7 | Yuvraj N |  | 2014-07-02 00:00:00 | 09:06 | 13:20 |  | 13:32 | 19:46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
8 | Kannan P |  | 2014-07-02 00:00:00
9 | Vijay V |  | 2014-07-02 00:00:00 | 10:09 | 11:13 |  | 11:28 | 12:55 | 12:55 |  | 13:21 |  | 13:35 | 15:54 | 15:55 |  | 17:40 | 17:48 | 18:22 | 21:43 |  |  |  | P
10 | [NAME]. M |  | 2014-07-02 00:00:00 | 13:54 | 19:46 |  | 20:04 | 22:02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
Log Date | 03 Jul 2014
Emp Code | Emp Name |  | Deparment | Log Records |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Status
1 | Satheesh P |  | 2014-07-03 00:00:00 | 09:38 | 13:21 |  | 13:37 | 19:22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
2 | [NAME] |  | 2014-07-03 00:00:00 | 13:37 | 22:02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
3 | Ranjith Prasanth C |  | 2014-07-03 00:00:00 | 06:25 | 17:05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
4 | [NAME] |  | 2014-07-03 00:00:00
5 | Harisankaran K S |  | 2014-07-03 00:00:00 | 09:38 | 19:28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
6 | [NAME] |  | 2014-07-03 00:00:00
7 | Yuvraj N |  | 2014-07-03 00:00:00 | 09:05 | 13:18 |  | 13:31 | 16:59 | 17:05 |  | 19:16 |  |  |  |  |  |  |  |  |  |  |  |  | P
8 | Kannan P |  | 2014-07-03 00:00:00
9 | Vijay V |  | 2014-07-03 00:00:00 | 01:35 | 20:51 |  | 21:07 | 21:07 | 22:20 |  | 22:29 |  |  |  |  |  |  |  |  |  |  |  |  | P
10 | [NAME]. M |  | 2014-07-03 00:00:00 | 15:14 | 19:15 |  | 19:27 | 22:04 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
Log Date | 04 Jul 2014
Emp Code | Emp Name |  | Deparment | Log Records |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Status
1 | Satheesh P |  | 2014-07-04 00:00:00 | 09:29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
2 | [NAME] |  | 2014-07-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
3 | Ranjith Prasanth C |  | 2014-07-04 00:00:00 | 06:23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
4 | [NAME] |  | 2014-07-04 00:00:00
5 | Harisankaran K S |  | 2014-07-04 00:00:00 | 09:27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
6 | [NAME] |  | 2014-07-04 00:00:00
7 | Yuvraj N |  | 2014-07-04 00:00:00 | 09:10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
8 | Kannan P |  | 2014-07-04 00:00:00
9 | Vijay V |  | 2014-07-04 00:00:00 | 01:37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
10 | [NAME]. M |  | 2014-07-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A