Spreadsheet: 25253d1216394608-formula-reference-formula-time_tracking_help
Sheet: Sheet1

 |  | JOB-01SM | JOB-01KB | JOB-01RO | [NAME] | JOB-02KB | JOB-02RO | JOB-03SM | JOB-03KB | JOB-03RO | JOB-04SM | [NAME] | JOB-04RO |  |  | WK1 | WK1 | WK1 | WK2 | WK2 | WK2 | WK3 | WK3 | WK3 | WK4 | WK4 | WK4
 | Table 1 | JOB-01 |  |  | JOB-02 |  |  | JOB-03 |  |  | [NAME] |  |  |  | Table 2 | WK1 |  |  | WK2 |  |  | WK3 |  |  | WK4
 |  | SM | KB | RO | SM | KB | RO | SM | KB | RO | SM | KB | RO |  |  | SM | KB | RO | SM | KB | RO | SM | KB | RO | SM | KB | RO
M | 2008-07-21 00:00:00 | 0 | 3 | 2 | 0 | 3 | 2 | 0 | 3 | 2 | 0 | 3 | 2 |  | JOB-01 | 24 | 22 | 15 | 33 | 34 | 21 | 35 | 21 | 20 | 35 | 21 | 21
T | 2008-07-22 00:00:00 | 8 | 5 | 0 | 8 | 5 | 0 | 8 | 5 | 0 | 8 | 5 | 0 |  | JOB-02 | 24 | 22 | 15 | 33 | 34 | 21 | 43.49999999999998 | 128.5000000000002 | 21 | 53.99999999999997 | 223.0000000000002 | 21
W | 2008-07-23 00:00:00 | 6 | 1 | 1 | 6 | 1 | 1 | 6 | 1 | 1 | 6 | 1 | 1 |  | JOB-03 | 24 | 22 | 15 | 33 | 34 | 21 | 167 | 128.5000000000002 | 21 | 270 | 223.0000000000002 | 21
T | 2008-07-24 00:00:00 | 2 | 5 | 0 | 2 | 5 | 0 | 2 | 5 | 0 | 2 | 5 | 0 |  | [NAME] | 24 | 22 | 15 | 33 | 34 | 21 | 43.49999999999998 | 128.5000000000002 | 21 | 53.99999999999997 | 223.0000000000002 | 21
F | 2008-07-25 00:00:00 | 3 | 5 | 5 | 3 | 5 | 5 | 3 | 5 | 5 | 3 | 5 | 5
S | 2008-07-26 00:00:00 | 5 | 3 | 5 | 5 | 3 | 5 | 5 | 3 | 5 | 5 | 3 | 5
S | 2008-07-27 00:00:00 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 0 | 2
WK1 | Total | 24 | 22 | 15 | 24 | 22 | 15 | 24 | 22 | 15 | 24 | 22 | 15
M | 2008-07-28 00:00:00 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
T | 2008-07-29 00:00:00 | 5 | 2 | 3 | 5 | 2 | 3 | 5 | 2 | 3 | 5 | 2 | 3
W | 2008-07-30 00:00:00 | 5 | 2 | 3 | 5 | 2 | 3 | 5 | 2 | 3 | 5 | 2 | 3
T | 2008-07-31 00:00:00 | 5 | 2 | 3 | 5 | 2 | 3 | 5 | 2 | 3 | 5 | 2 | 3
F | 2008-08-01 00:00:00 | 5 | 2 | 3 | 5 | 2 | 3 | 5 | 2 | 3 | 5 | 2 | 3
S | 2008-08-02 00:00:00 | 5 | 2 | 3 | 5 | 2 | 3 | 5 | 2 | 3 | 5 | 2 | 3
S | 2008-08-03 00:00:00 | 5 | 21 | 3 | 5 | 21 | 3 | 5 | 21 | 3 | 5 | 21 | 3
WK2 | Total | 33 | 34 | 21 | 33 | 34 | 21 | 33 | 34 | 21 | 33 | 34 | 21
M | 2008-08-04 00:00:00 | 5 | 3 | 2 | 5.57142857142857 | 12.5714285714286 | 3 | 10 | 12.5714285714286 | 3 | 5.57142857142857 | 12.5714285714286 | 3
T | 2008-08-05 00:00:00 | 5 | 3 | 3 | 5.78571428571428 | 14.5 | 3 | 10 | 14.5 | 3 | 5.78571428571428 | 14.5 | 3
W | 2008-08-06 00:00:00 | 5 | 3 | 3 | 6 | 16.4285714285715 | 3 | 10 | 16.4285714285715 | 3 | 6 | 16.4285714285715 | 3
T | 2008-08-07 00:00:00 | 5 | 3 | 3 | 6.21428571428571 | 18.3571428571429 | 3 | 55 | 18.3571428571429 | 3 | 6.21428571428571 | 18.3571428571429 | 3
F | 2008-08-08 00:00:00 | 5 | 3 | 3 | 6.42857142857143 | 20.2857142857143 | 3 | 55 | 20.2857142857143 | 3 | 6.42857142857143 | 20.2857142857143 | 3
S | 2008-08-09 00:00:00 | 5 | 3 | 3 | 6.64285714285714 | 22.2142857142857 | 3 | 15 | 22.2142857142857 | 3 | 6.64285714285714 | 22.2142857142857 | 3
S | 2008-08-10 00:00:00 | 5 | 3 | 3 | 6.85714285714285 | 24.1428571428572 | 3 | 12 | 24.1428571428572 | 3 | 6.85714285714285 | 24.1428571428572 | 3
WK3 | Total | 35 | 21 | 20 | 43.49999999999998 | 128.5000000000002 | 21 | 167 | 128.5000000000002 | 21 | 43.49999999999998 | 128.5000000000002 | 21
M | 2008-08-11 00:00:00 | 5 | 3 | 3 | 7.07142857142857 | 26.0714285714286 | 3 | 20 | 26.0714285714286 | 3 | 7.07142857142857 | 26.0714285714286 | 3
T | 2008-08-12 00:00:00 | 5 | 3 | 3 | 7.28571428571428 | 28 | 3 | 20 | 28 | 3 | 7.28571428571428 | 28 | 3
W | 2008-08-13 00:00:00 | 5 | 3 | 3 | 7.5 | 29.9285714285715 | 3 | 222 | 29.9285714285715 | 3 | 7.5 | 29.9285714285715 | 3
T | 2008-08-14 00:00:00 | 5 | 3 | 3 | 7.71428571428571 | 31.8571428571429 | 3 | 2 | 31.8571428571429 | 3 | 7.71428571428571 | 31.8571428571429 | 3
F | 2008-08-15 00:00:00 | 5 | 3 | 3 | 7.92857142857142 | 33.7857142857143 | 3 | 2 | 33.7857142857143 | 3 | 7.92857142857142 | 33.7857142857143 | 3
S | 2008-08-16 00:00:00 | 5 | 3 | 3 | 8.14285714285714 | 35.7142857142857 | 3 | 2 | 35.7142857142857 | 3 | 8.14285714285714 | 35.7142857142857 | 3
S | 2008-08-17 00:00:00 | 5 | 3 | 3 | 8.35714285714285 | 37.6428571428572 | 3 | 2 | 37.6428571428572 | 3 | 8.35714285714285 | 37.6428571428572 | 3
WK4 | Total | 35 | 21 | 21 | 53.99999999999997 | 223.0000000000002 | 21 | 270 | 223.0000000000002 | 21 | 53.99999999999997 | 223.0000000000002 | 21