Spreadsheet: 133279d1324313717-excel-2007-changing-the-month-daily-schedule
Sheet: Sheet5

 |  |  | Emp. No. | Employee Name | Date | Day | Time In | Time Out | Work Duration | Status |  | Match | Vlookup
 |  |  | 83667 | ARCHANA MALIK | 2011-12-14 00:00:00 | Wed | 12:40:11 | 22:14:05 | 09:33:54 | Present |  | 11 | ARCHANA MALIK
 |  |  | 39119 | Amit Raj | 2011-12-14 00:00:00 | Wed |  |  |  | Prezenza Sign in/Sign out |  |  | Amit Raj
 |  |  | 77967 | DEEP KUNDU | 2011-12-14 00:00:00 | Wed | 13:00:04 | 22:39:47 | 09:39:43 | Present |  |  | DEEP KUNDU
 |  |  | 54190 | [NAME] | 2011-12-14 00:00:00 | Wed | 13:52:52 | 22:58:37 | 09:05:45 | Present |  |  | [NAME]
 |  |  | 46026 | Himanshu Pande | 2011-12-14 00:00:00 | Wed | 13:51:00 | 23:03:00 | 09:12:00 | Present |  |  | Himanshu Pande
 |  |  | 54185 | Inder [NAME] | 2011-12-14 00:00:00 | Wed | 14:13:16 | 23:11:40 | 08:58:24 | Present |  |  | Inder [NAME]
 |  |  | 91093 | Lalit Dayal | 2011-12-14 00:00:00 | Wed | 13:11:28 | 23:04:45 | 09:53:17 | Present |  |  | Lalit Dayal
 |  |  | 38668 | Lavish Dhand | 2011-12-14 00:00:00 | Wed | 13:32:11 | 23:27:19 | 09:55:08 | Present |  |  | Lavish Dhand
 |  |  | 96154 | [NAME] | 2011-12-14 00:00:00 | Wed | 13:51:59 | 23:03:44 | 09:11:45 | Present |  |  | [NAME]
 |  |  | 86619 | Manthan Agarwal | 2011-12-14 00:00:00 | Wed | 13:56:41 | 23:01:54 | 09:05:13 | Present |  |  | Manthan Agarwal
 |  |  | 80239 | [NAME] | 2011-12-14 00:00:00 | Wed | 13:53:11 | 23:06:29 | 09:13:18 | Present |  |  | [NAME]
 |  |  | 91088 | [NAME] | 2011-12-14 00:00:00 | Wed | 13:49:14 | 23:03:07 | 09:13:53 | Present |  |  | [NAME]
 |  |  | 84568 | [NAME] | 2011-12-14 00:00:00 | Wed | 13:57:37 | 23:13:47 | 09:16:10 | Present |  |  | [NAME]
 |  |  | 73699 | NIdhi Bhatt | 2011-12-14 00:00:00 | Wed | 13:10:44 | 22:20:53 | 09:10:09 | Present |  |  | NIdhi Bhatt
 |  |  | 99613 | Nishant Kukreja | 2011-12-14 00:00:00 | Wed | 13:54:04 | 23:01:31 | 09:07:27 | Present |  |  | Nishant Kukreja
 |  |  | 62175 | PUSHPINDER BARJATYA | 2011-12-14 00:00:00 | Wed | 14:02:32 | 23:00:56 | 08:58:24 | Present |  |  | PUSHPINDER BARJATYA
 |  |  | 96411 | Paresh Pathak | 2011-12-14 00:00:00 | Wed | 13:36:58 | 23:02:05 | 09:25:07 | Present |  |  | Paresh Pathak
 |  |  | 57515 | Poonam Singh | 2011-12-14 00:00:00 | Wed | 13:24:15 | 23:14:24 | 09:50:09 | Present |  |  | Poonam Singh
 |  |  | 52450 | [NAME] | 2011-12-14 00:00:00 | Wed | 13:48:41 | 23:11:06 | 09:22:25 | Present |  |  | [NAME]
 |  |  | 44440 | [NAME] | 2011-12-14 00:00:00 | Wed | 14:06:36 | 23:14:02 | 09:07:26 | Present |  |  | [NAME]
 |  |  | 100310 | [NAME] | 2011-12-14 00:00:00 | Wed | 13:59:02 | 23:05:03 | 09:06:01 | Present |  |  | [NAME]
 |  |  | 34563 | [NAME] | 2011-12-14 00:00:00 | Wed |  |  |  | Prezenza Sign in/Sign out |  |  | [NAME]
 |  |  | 53825 | [NAME] | 2011-12-14 00:00:00 | Wed | 18:34:47 | 23:13:17 | 04:38:30 | Half Day Absent |  |  | [NAME]
 |  |  | 38476 | Rohit Tyagi | 2011-12-14 00:00:00 | Wed | 12:38:59 | 19:51:46 | 07:12:47 | Half Day Absent |  |  | Rohit Tyagi
 |  |  | 40587 | [NAME] | 2011-12-14 00:00:00 | Wed | 12:50:04 | 22:20:12 | 09:30:08 | Present |  |  | [NAME]
 |  |  | 72197 | [NAME] | 2011-12-14 00:00:00 | Wed | 13:33:46 | 22:51:10 | 09:17:24 | Present |  |  | [NAME]
 |  |  | 92444 | [NAME] | 2011-12-14 00:00:00 | Wed | 13:56:02 | 23:01:50 | 09:05:48 | Present |  |  | [NAME]
 |  |  | 73157 | TANUJA KHILWANI | 2011-12-14 00:00:00 | Wed | 13:56:51 | 23:20:41 | 09:23:50 | Present |  |  | TANUJA KHILWANI
 |  |  | 89141 | VIKAS VARMA | 2011-12-14 00:00:00 | Wed | 13:38:25 | 23:00:52 | 09:22:27 | Present |  |  | VIKAS VARMA