Spreadsheet: 230740d1366860296-time-card-spread-sheet-help-copy-of-time-card-rec-a
Sheet: STAFF MEMBER

Staff Member - VALETER
8.30 TO 5.0  - 5 DAY WEEK
 | Week One
 | Date | Start Time - Job card | Start Time - Actual | End Time - Job card | End Time - Actual | Lunch | Hours worked | Contracted Hours | Overtime
M | 2013-03-25 00:00:00 | 8.35 | 08:21 | 16.95 | 16:41 | 00:30:00 | 7.833333333333334 | 8 | 0
T | 2013-03-26 00:00:00 | 8.34 | 08:20 | 16.96 | 16:41 | 00:30:00 | 7.849999999999999 | 8 | 0
W | 2013-03-27 00:00:00 | 8.31 | 08:19 | 16.97 | 16:41 | 00:30:00 | 7.866666666666667 | 8 | 0
T | 2013-03-28 00:00:00 | 8.06 | 08:04 | 17.23 | 17:43 | 00:30:00 | 9.149999999999999 | 8 | 1.149999999999999 | Hours worked 8.67 !!
F | 2013-03-29 00:00:00 | HOLIDAY |  |  |  |  | 8 | 8 | 0
 |  |  |  | Total hours worked |  |  | 40.7 | 40 | 1.149999999999999
 | Week Two
 | Date | Start Time - Job card | Start Time - Actual | End Time - Job card | End Time - Actual | Lunch | Hours worked | Contracted Hours | Overtime
M | 2013-04-01 00:00:00 | HOLIDAY |  |  |  |  | 8 | 8 | 0
T | 2013-04-02 00:00:00 | 7.24 | 07:14 | 16.98 | 16:41 | 00:30:00 | 8.95 | 8 | 0.9499999999999993
W | 2013-04-03 00:00:00 | 8.4 | 08:24 | 17.04 | 17:42 | 00:30:00 | 8.799999999999997 | 8 | 0.7999999999999972 | Hours worked 0.13 !!
T | 2013-04-04 00:00:00 | 8.39 | 08:23 | 16.97 | 16:41 | 00:30:00 | 7.800000000000001 | 8 | 0
F | 2013-04-05 00:00:00 | 8.41 | 08:25 | 16.89 | 16:41 | 00:30:00 | 7.766666666666667 | 8 | 0
 |  |  |  | Total hours worked |  |  | 41.31666666666666 | 40 | 1.749999999999996
 | Week Three
 | Date | Start Time - Job card | Start Time - Actual | End Time - Job card | End Time - Actual | Lunch | Hours worked | Contracted Hours | Overtime
M | 2013-04-08 00:00:00 | 8.39 | 08:23 | 17.46 | 17:44 | 00:30:00 | 8.850000000000001 | 8 | 0.8500000000000014
T | 2013-04-09 00:00:00 | 8.35 | 08:21 | 16.92 | 16:41 | 00:30:00 | 7.833333333333334 | 8 | 0
W | 2013-04-10 00:00:00 | 8.27 | 08:16 | 16.96 | 16:41 | 00:30:00 | 7.916666666666665 | 8 | 0
T | 2013-04-11 00:00:00 | 8.39 | 08:23 | 16.97 | 16:41 | 00:30:00 | 7.800000000000001 | 8 | 0
F | 2013-04-12 00:00:00 | 8.27 | 08:16 | 17.01 | 17:42 | 00:30:00 | 8.93333333333333 | 8 | 0.93333333333333
S | 2013-04-13 00:00:00 | 8.36 | 08:22 | 17.25 | 17:43 | 00:30:00 | 8.849999999999998 | 8 | 0.8499999999999979
 |  |  |  | Total hours worked |  |  | 50.18333333333334 | 48 | 2.633333333333329
 | Week Four
 | Date | Start Time - Job card | Start Time - Actual | End Time - Job card | End Time - Actual | Lunch | Hours worked | Contracted Hours | Overtime
M | 2013-04-15 00:00:00 | 8.31 | 08:19 | 16.86 | 16:41 | 00:30:00 | 7.866666666666667 | 8 | 0
T | 2013-04-16 00:00:00 | 8.15 | 08:09 | 16.96 | 16:41 | 00:30:00 | 8.033333333333333 | 8 | 0.03333333333333321
W | 2013-04-17 00:00:00 | 8.26 | 08:16 | 16.98 | 16:41 | 00:30:00 | 7.916666666666665 | 8 | 0
T | 2013-04-18 00:00:00 | 8.3 | 08:18 | 16.91 | 16:41 | 00:30:00 | 7.883333333333332 | 8 | 0 | Hours worked 0.12 !!
F | 2013-04-19 00:00:00 | 8.17 | 08:10 | 16.94 | 16:41 | 00:30:00 | 8.016666666666667 | 8 | 0.0166666666666675
 |  |  |  | Total hours worked |  |  | 39.71666666666667 | 40 | 0.05000000000000071
 |  |  |  | Total hours worked for the Month |  |  | 171.9166666666667 | 168 | 5.583333333333325