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

Employee Masters |  |  |  |  |  | Log Records |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summarry
Attn Code | Emp No | Employee Name |  | Date |  | In1 | Out1 | [NAME] | In2 | Out2 | [NAME] | In3 | Out3 | [NAME] | In4 | Out4 | [NAME] | In5 | Out5 | [NAME] | In6 | Out6 | [NAME] | In7 | Out7 | [NAME] | In8 | Out8 | [NAME] |  | Total IN Punch | Total OUT Punch | Total Break Hrs
1 | 1804 | Satheesh P |  | 2014-07-01 00:00:00 |  | 09:26 | 13:28 | 00:19:00 | 13:47 | 20:10 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 2 | 2 | 00:19:00
2 | 1809 | [NAME] |  | 2014-07-01 00:00:00 |  | 13:39 | 22:02 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 1 | 1
3 | 1813 | Ranjith Prasanth C |  | 2014-07-01 00:00:00 |  | 06:13 | 16:13 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 1 | 1
5 | 1820 | Harisankaran K S |  | 2014-07-01 00:00:00 |  | 09:33 | 19:12 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 1 | 1
7 | 1826 | Yuvraj N |  | 2014-07-01 00:00:00 |  | 08:58 | 13:15 | 00:10:00 | 13:25 | 17:21 | 00:08:00 | 17:29 | 18:51 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 3 | 3 | 00:18:00
9 | 1838 | Vijay V |  | 2014-07-01 00:00:00 |  | 01:39 | 11:34 | 01:42:00 | 13:16 | 13:33 | 02:38:00 | 16:11 | 16:37 | 01:57:00 | 18:34 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 4 | 3 | 06:17:00
10 | 1845 | [NAME]. M |  | 2014-07-01 00:00:00 |  | 13:59 | 19:01 | 00:10:00 | 19:11 | 22:03 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 2 | 2 | 00:10:00
1 | 1804 | Satheesh P |  | 2014-07-02 00:00:00 |  | 09:32 | 13:28 | 00:20:00 | 13:48 | 19:28 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 2 | 2 | 00:20:00
2 | 1809 | [NAME] |  | 2014-07-02 00:00:00 |  | 13:45 | 22:03 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
3 | 1813 | Ranjith Prasanth C |  | 2014-07-02 00:00:00 |  | 06:25 | 07:54 |  | 08:36 | 14:59 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
5 | 1820 | Harisankaran K S |  | 2014-07-02 00:00:00 |  | 09:38 | 21:12 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
7 | 1826 | Yuvraj N |  | 2014-07-02 00:00:00 |  | 09:06 | 13:20 |  | 13:32 | 19:46 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
9 | 1838 | 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 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
10 | 1845 | [NAME]. M |  | 2014-07-02 00:00:00 |  | 13:54 | 19:46 |  | 20:04 | 22:02 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1 | 1804 | Satheesh P |  | 2014-07-03 00:00:00 |  | 09:38 | 13:21 |  | 13:37 | 19:22 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
2 | 1809 | [NAME] |  | 2014-07-03 00:00:00 |  | 13:37 | 22:02 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
3 | 1813 | Ranjith Prasanth C |  | 2014-07-03 00:00:00 |  | 06:25 | 17:05 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
5 | 1820 | Harisankaran K S |  | 2014-07-03 00:00:00 |  | 09:38 | 19:28 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
7 | 1826 | Yuvraj N |  | 2014-07-03 00:00:00 |  | 09:05 | 13:18 |  | 13:31 | 16:59 |  | 17:05 | 19:16 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
9 | 1838 | Vijay V |  | 2014-07-03 00:00:00 |  | 01:35 | 20:51 |  | 21:07 | 21:07 |  | 22:20 | 22:29 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
10 | 1845 | [NAME]. M |  | 2014-07-03 00:00:00 |  | 15:14 | 19:15 |  | 19:27 | 22:04 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1 | 1804 | Satheesh P |  | 2014-07-04 00:00:00 |  | 09:29 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
2 | 1809 | [NAME] |  | 2014-07-04 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
3 | 1813 | Ranjith Prasanth C |  | 2014-07-04 00:00:00 |  | 06:23 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
5 | 1820 | Harisankaran K S |  | 2014-07-04 00:00:00 |  | 09:27 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
7 | 1826 | Yuvraj N |  | 2014-07-04 00:00:00 |  | 09:10 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
9 | 1838 | Vijay V |  | 2014-07-04 00:00:00 |  | 01:37 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
10 | 1845 | [NAME]. M |  | 2014-07-04 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00