Spreadsheet: 151055d1334766906-need-help-setting-up-an-attendance-tracker-attendance-tracker
Sheet: Attendence Tracker

 |  | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
Name |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
[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 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | George | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | WE
Shifts | 09:30:00 | 12:30:00 | 15:30:00 |  |  |  |  |  |  |  |  |  | PL
 |  |  |  |  |  |  |  |  |  |  |  |  | SL
 |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00
Total No of Leaves for each person |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
 | Total No Planned Leaves for each person |  |  |  |  |  |  |  |  |  |  |  | 15:30:00
 | Total No Sick Leaves for each person
Total No of 9:30, 12:30, and 15:30 shifts per person
Need all above info on a full total basis as well as a monthly basis