Spreadsheet: 134653d1325545611-extract-login-and-logut-data-from-one-worksheet-to-another-index
Sheet: Rawdata

date | employee name | ext | login | logout
2011-12-01 00:00:00 | [NAME] | 3458325 | 08:32:00 | 12:30:00
2011-12-01 00:00:00 | EMPLOYEE2 | 3458214 | 09:00:00 | 17:30:00
2011-12-01 00:00:00 | EMPLOYEE3 | 3458215 | 08:00:00 | 16:43:00
2011-12-01 00:00:00 | EMPLOYEE4 | 3458216 | 11:00:00 | 19:30:00
2011-12-01 00:00:00 | EMPLOYEE5 | 3458217 | 13:00:00 | 22:30:00
2011-12-01 00:00:00 | EMPLOYEE6 | 3458218 | 09:00:00 | 19:00:00
2011-12-01 00:00:00 | EMPLOYEE7 | 3458219 | 10:00:00 | 20:00:00
2011-12-01 00:00:00 | EMPLOYEE8 | 3458220 | 11:00:00 | 21:00:00
2011-12-01 00:00:00 | EMPLOYEE9 | 3458221 | 12:00:00 | 22:00:00
2011-12-01 00:00:00 | EMPLOYEE10 | 3458222 | 13:00:00 | 23:00:00
2011-12-01 00:00:00 | EMPLOYEE11 | 3458223 | 14:00:00 | 23:00:00
2011-12-01 00:00:00 | EMPLOYEE12 | 3458224 | 15:00:00 | 21:00:00
2011-12-01 00:00:00 | EMPLOYEE13 | 3458225 | 16:00:00 | 22:00:00
2011-12-01 00:00:00 | EMPLOYEE14 | 3458326 | 07:17:00 | 15:30:00
2011-12-01 00:00:00 | EMPLOYEE15 | 3458227 | 08:17:00 | 16:30:00
2011-12-01 00:00:00 | EMPLOYEE16 | 3458228 | 09:17:00 | 17:30:00
2011-12-01 00:00:00 | EMPLOYEE17 | 3458229 | 10:17:00 | 18:30:00
2011-12-01 00:00:00 | EMPLOYEE18 | 3458230 | 11:17:00 | 19:30:00
2011-12-01 00:00:00 | EMPLOYEE19 | 3458231 | 12:17:00 | 20:30:00
2011-12-01 00:00:00 | EMPLOYEE20 | 3458232 | 13:17:00 | 21:30:00
2011-12-02 00:00:00 | EMPLOYEE2 | 3458325 | 15:10:00 | 18:30:00
2011-12-02 00:00:00 | EMPLOYEE3 | 3458214 | 07:00:00 | 12:00:00
2011-12-02 00:00:00 | EMPLOYEE4 | 3458215 | 08:00:00 | 13:00:00
2011-12-02 00:00:00 | EMPLOYEE5 | 3458216 | 09:00:00 | 14:00:00
2011-12-02 00:00:00 | [NAME] | 3458217 | 10:00:00 | 15:00:00
2011-12-02 00:00:00 | EMPLOYEE7 | 3458218 | 11:00:00 | 16:00:00
2011-12-02 00:00:00 | EMPLOYEE10 | 3458219 | 12:00:00 | 17:00:00
2011-12-02 00:00:00 | EMPLOYEE6 | 3458220 | 13:00:00 | 18:00:00
2011-12-02 00:00:00 | EMPLOYEE8 | 3458221 | 14:00:00 | 19:00:00
2011-12-02 00:00:00 | EMPLOYEE11 | 3458222 | 15:00:00 | 20:00:00
2011-12-02 00:00:00 | EMPLOYEE9 | 3458223 | 10:11:00 | 21:00:00
2011-12-02 00:00:00 | EMPLOYEE12 | 3458224 | 11:11:00 | 22:00:00
2011-12-02 00:00:00 | EMPLOYEE14 | 3458225 | 12:11:00 | 23:00:00
2011-12-02 00:00:00 | EMPLOYEE13 | 3458326 | 13:11:00 | 17:00:00
2011-12-02 00:00:00 | EMPLOYEE18 | 3458227 | 14:11:00 | 18:00:00
2011-12-02 00:00:00 | EMPLOYEE15 | 3458228 | 15:11:00 | 19:00:00
2011-12-02 00:00:00 | EMPLOYEE16 | 3458229 | 16:11:00 | 20:00:00
2011-12-02 00:00:00 | EMPLOYEE17 | 3458230 | 17:11:00 | 21:00:00
2011-12-02 00:00:00 | EMPLOYEE19 | 3458231 | 18:11:00 | 22:00:00
2011-12-02 00:00:00 | EMPLOYEE20 | 3458232 | 19:11:00 | 23:00:00
2011-12-03 00:00:00 | [NAME] | 3458325 | 08:32:00 | 12:30:00
2011-12-03 00:00:00 | EMPLOYEE2 | 3458214 | 09:00:00 | 17:30:00
2011-12-03 00:00:00 | EMPLOYEE3 | 3458215 | 08:00:00 | 16:43:00
2011-12-03 00:00:00 | EMPLOYEE4 | 3458216 | 11:00:00 | 19:30:00
2011-12-03 00:00:00 | EMPLOYEE5 | 3458217 | 13:00:00 | 22:30:00
2011-12-03 00:00:00 | EMPLOYEE6 | 3458218 | 09:00:00 | 19:00:00
2011-12-03 00:00:00 | EMPLOYEE7 | 3458219 | 10:00:00 | 20:00:00
2011-12-03 00:00:00 | EMPLOYEE8 | 3458220 | 11:00:00 | 21:00:00
2011-12-03 00:00:00 | EMPLOYEE9 | 3458221 | 12:00:00 | 22:00:00
2011-12-03 00:00:00 | EMPLOYEE10 | 3458222 | 13:00:00 | 23:00:00
2011-12-03 00:00:00 | EMPLOYEE11 | 3458223 | 14:00:00 | 23:00:00
2011-12-03 00:00:00 | EMPLOYEE12 | 3458224 | 15:00:00 | 21:00:00
2011-12-03 00:00:00 | EMPLOYEE13 | 3458225 | 16:00:00 | 22:00:00
2011-12-03 00:00:00 | EMPLOYEE14 | 3458326 | 07:17:00 | 15:30:00
2011-12-03 00:00:00 | EMPLOYEE15 | 3458227 | 08:17:00 | 16:30:00
2011-12-03 00:00:00 | EMPLOYEE16 | 3458228 | 09:17:00 | 17:30:00
2011-12-03 00:00:00 | EMPLOYEE17 | 3458229 | 10:17:00 | 18:30:00
2011-12-03 00:00:00 | EMPLOYEE18 | 3458230 | 11:17:00 | 19:30:00
2011-12-03 00:00:00 | EMPLOYEE19 | 3458231 | 12:17:00 | 20:30:00
2011-12-03 00:00:00 | EMPLOYEE20 | 3458325 | 13:17:00 | 21:30:00
2011-12-04 00:00:00 | [NAME] | 3458214 | 15:10:00 | 18:30:00
2011-12-04 00:00:00 | EMPLOYEE2 | 3458215 | 07:00:00 | 12:00:00
2011-12-04 00:00:00 | EMPLOYEE3 | 3458216 | 08:00:00 | 13:00:00
2011-12-04 00:00:00 | EMPLOYEE4 | 3458217 | 09:00:00 | 14:00:00
2011-12-04 00:00:00 | EMPLOYEE5 | 3458218 | 10:00:00 | 15:00:00
2011-12-04 00:00:00 | EMPLOYEE6 | 3458219 | 11:00:00 | 16:00:00
2011-12-04 00:00:00 | EMPLOYEE7 | 3458220 | 12:00:00 | 17:00:00
2011-12-04 00:00:00 | EMPLOYEE8 | 3458221 | 13:00:00 | 18:00:00
2011-12-04 00:00:00 | EMPLOYEE9 | 3458222 | 14:00:00 | 19:00:00
2011-12-04 00:00:00 | EMPLOYEE10 | 3458223 | 15:00:00 | 20:00:00
2011-12-04 00:00:00 | EMPLOYEE11 | 3458224 | 10:11:00 | 21:00:00
2011-12-04 00:00:00 | EMPLOYEE12 | 3458225 | 11:11:00 | 22:00:00
2011-12-04 00:00:00 | EMPLOYEE13 | 3458326 | 12:11:00 | 23:00:00
2011-12-04 00:00:00 | EMPLOYEE14 | 3458227 | 13:11:00 | 17:00:00
2011-12-04 00:00:00 | EMPLOYEE15 | 3458228 | 14:11:00 | 18:00:00
2011-12-04 00:00:00 | EMPLOYEE16 | 3458229 | 15:11:00 | 19:00:00
2011-12-04 00:00:00 | EMPLOYEE17 | 3458230 | 16:11:00 | 20:00:00
2011-12-04 00:00:00 | EMPLOYEE18 | 3458231 | 17:11:00 | 21:00:00
2011-12-04 00:00:00 | EMPLOYEE19 | 3458224 | 18:11:00 | 22:00:00
2011-12-04 00:00:00 | EMPLOYEE20 | 3458225 | 19:11:00 | 23:00:00