Spreadsheet: 151279d1334849122-using-pivot-table-for-sheet-attendance-tracker1
Sheet: Attendence Tracker

 |  | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
Name | 2012-11-01 00:00:00 | 2012-11-02 00:00:00 | 2012-11-03 00:00:00 | 2012-11-04 00:00:00 | 2012-11-05 00:00:00 | 2012-11-06 00:00:00 | 2012-11-07 00:00:00 | 2012-11-08 00:00:00 | 2012-11-09 00:00:00 | 2012-11-10 00:00:00 | 2012-11-11 00:00:00 | 2012-11-12 00:00:00 | 2012-11-13 00:00:00 | 2012-11-14 00:00:00 | 2012-11-15 00:00:00 | 2012-11-16 00:00:00 | 2012-11-17 00:00:00 | 2012-11-18 00:00:00 | 2012-11-19 00:00:00 | 2012-11-20 00:00:00 | 2012-11-21 00:00:00 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 2012-11-24 00:00:00 | 2012-11-25 00:00:00 | 2012-11-26 00:00:00 | 2012-11-27 00:00:00 | 2012-11-28 00:00:00 | 2012-11-29 00:00:00 | 2012-11-30 00:00:00 | 2012-12-01 00:00:00 | 2012-12-02 00:00:00 | 2012-12-03 00:00:00 | 2012-12-04 00:00:00 | 2012-12-05 00:00:00 | 2012-12-06 00:00:00 | 2012-12-07 00:00:00 | 2012-12-08 00:00:00 | 2012-12-09 00:00:00 | 2012-12-10 00:00:00 | 2012-12-11 00:00:00 | 2012-12-12 00:00:00 | 2012-12-13 00:00:00 | 2012-12-14 00:00:00 | 2012-12-15 00:00:00 | 2012-12-16 00:00:00 | 2012-12-17 00:00:00 | 2012-12-18 00:00:00 | 2012-12-19 00:00:00 | 2012-12-20 00:00:00 | 2012-12-21 00:00:00 | 2012-12-22 00:00:00 | 2012-12-23 00:00:00 | 2012-12-24 00:00:00 | 2012-12-25 00:00:00 | 2012-12-26 00:00:00 | 2012-12-27 00:00:00 | 2012-12-28 00:00:00 | 2012-12-29 00:00:00 | 2012-12-30 00:00:00 | 2012-12-31 00:00:00
[NAME] | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 15:30:00 | 15:30:00 | 15:30:00 | 15:30:00 | 15:30:00 | We | We | PL | PL | 15:30:00 | 15:30:00 | 15:30:00 | We | We | 15:30:00 | 15:30:00 | 15:30:00 | 15:30:00
[NAME] | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 12:30:00 | PL | PL | PL | PL | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 15:30:00 | 15:30:00 | 15:30:00 | 15:30:00 | 15:30:00 | We | We | 15:30:00 | 15:30:00 | 15:30:00 | 15:30:00 | 15:30:00 | We | We | 15:30:00 | 15:30:00 | 15:30:00 | 15:30:00
[NAME] | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 12:30:00 | PL | PL | 12:30:00
George | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 12:30:00 | 12:30:00 | SL | SL | 12:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00
[NAME] | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | SL | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00 | We | We | 12:30:00 | 12:30:00 | 12:30:00 | 12:30:00
PL - Planned Leave
SL - Sick Leave
Shifts | 09:30:00 | 12:30:00 | 15:30:00