Spreadsheet: 99541d1298151147-convert-non-data-base-to-data-base-format-using-formula-emp-unit2-test1
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 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00 | 2011-01-31 00:00:00
1001 | THOMAS | P | WO | P | P | P | P | P | P | WO | P | P | P | P | P | P | WO | A | P | P | P | P | P | WO | P | P | P | P | A | P | WO | P
1002 | GREIGE | P | WO | P | P | A | P | P | P | WO | P | P | P | P | P | A | WO | P | P | P | A | P | P | WO | P | P | P | P | P | P | WO | P
1003 | [NAME] | P | WO | P | P | P | P | P | P | WO | P | P | P | P | P | P | WO | P | P | P | P | P | P | WO | P | P | P | P | A | P | WO | P
1004 | FERNANDES | P | WO | P | P | P | A | P | P | WO | P | P | A | P | P | P | WO | P | P | P | P | P | A | WO | P | P | P | P | P | P | WO | P
1005 | MEGAN | P | WO | P | P | P | P | P | A | WO | P | P | P | P | P | P | WO | P | P | P | P | P | P | WO | P | P | P | P | A | P | WO | P
1006 | BRIGITTE | P | WO | P | P | P | P | P | P | WO | P | A | P | P | P | P | WO | P | P | P | P | P | P | WO | P | P | P | P | P | P | WO | P
1007 | DARREN | P | WO | P | A | P | P | P | P | WO | P | P | P | A | P | P | WO | P | P | P | P | P | P | WO | P | P | P | P | P | P | WO | P
1008 | TOWEN | P | WO | P | P | P | P | P | P | WO | P | P | P | P | P | P | WO | P | P | P | P | P | A | WO | A | P | P | P | P | P | WO | P
1009 | MORGAN | P | WO | P | P | P | P | P | P | WO | A | P | P | P | P | P | WO | P | P | P | P | P | P | WO | P | P | P | P | A | P | WO | P
1010 | STANLY | P | WO | P | P | P | P | P | P | WO | P | P | P | A | P | A | WO | P | P | P | P | P | P | WO | A | P | P | P | P | P | WO | P
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00