Spreadsheet: 99766d1298339400-convert-non-data-base-to-data-base-format-using-formula-emp-unit2-test2
Sheet: ATTENDANCE

EMP NO | EMP NAME | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00
1001 | THOMAS | P | WO | P | P | P | P | P | P | WO
1002 | GREIGE | P | WO | P | P | A | P | P | P | WO
1003 | [NAME] | P | WO | P | P | P | P | P | P | WO
1004 | FERNANDES | P | WO | P | P | P | A | P | P | WO
1005 | MEGAN | P | WO | P | P | P | P | P | A | WO
1006 | BRIGITTE | P | WO | P | P | P | P | P | P | WO
1007 | DARREN | P | WO | P | A | P | P | P | P | WO
1008 | TOWEN | P | WO | P | P | P | P | P | P | WO
1009 | MORGAN | P | WO | P | P | P | P | P | P | WO
1010 | STANLY | P | WO | P | P | P | P | P | P | WO
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00