Spreadsheet: 230605d1366818226-time-card-spread-sheet-help-time-sheet
Sheet: Sheet1

Name | Date | Pay Period | Clock In | Clock Out | Clock In | Clock Out | Total Hours | Regular Hrs | Overtime | Weekend |  |  |  |  |  |  |  |  |  |  |  |  |  | Data Validation List |  |  | Pay Period | Week | Year |  |  | PP | WK
[NAME] | 2012-01-02 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
[NAME] | 2012-01-02 00:00:00 |  | 08:00:00 | 12:30:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee List |  |  |  |  |  |  |  | 2 | 1
[NAME] | 2012-01-02 00:00:00 |  | 04:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2
[NAME] | 2012-01-02 00:00:00 |  | 09:00:00 | 12:00:00 | 13:00:00 | 16:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2
[NAME] | 2012-01-02 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 3
[NAME] | 2012-01-03 00:00:00 |  | 07:00:00 | 12:00:00 | 13:00:00 | 17:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 3
[NAME] | 2012-01-03 00:00:00 |  | 04:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 4
[NAME] | 2012-01-03 00:00:00 |  | 06:00:00 | 12:00:00 | 13:45:00 | 18:10:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 4
[NAME] | 2012-01-03 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 5
[NAME] | 2012-01-03 00:00:00 |  | 04:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 5
[NAME] | 2012-01-12 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 6
[NAME] | 2012-01-12 00:00:00 |  | 04:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 6
[NAME] | 2012-01-12 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 7
[NAME] | 2012-01-12 00:00:00 |  | 04:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 7
[NAME] | 2012-01-12 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 8
[NAME] | 2012-01-17 00:00:00 |  | 08:56:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 8
[NAME] | 2012-01-17 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 9
[NAME] | 2012-01-17 00:00:00 |  | 04:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 9
[NAME] | 2012-01-17 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | 10
[NAME] | 2012-01-17 00:00:00 |  | 04:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 10
[NAME] | 2012-01-22 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 11
[NAME] | 2012-01-22 00:00:00 |  | 04:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 11
[NAME] | 2012-01-22 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 12
[NAME] | 2012-01-22 00:00:00 |  | 04:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 12
[NAME] | 2012-01-22 00:00:00 |  |  |  | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 13
[NAME] | 2012-01-27 00:00:00 |  | 08:00:00 | 12:15:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 13
[NAME] | 2012-01-27 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | 14
[NAME] | 2012-01-27 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 14
[NAME] | 2012-01-27 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 15
[NAME] | 2012-01-27 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 15
[NAME] | 2012-01-28 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 16
[NAME] | 2012-01-28 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 16
[NAME] | 2012-01-28 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 17
[NAME] | 2012-01-28 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 17
[NAME] | 2012-01-28 00:00:00 |  | 08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 18
[NAME] | 2012-03-03 00:00:00 |  | 08:00:00 | 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52 | 26