Spreadsheet: 724884d1616430502-index-match-function-lookup-cell-is-formula-want-it-to-look-for-result-of-formula-example-for-hours-log
Sheet: Daily Hours

Month | March
Home | 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 | TOT | Min hrs | Actual/4.43 | High Hours |  | Hrs (Under/Over)
Day/Wk | 2021-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OBO
R1 |  | 62 | 62 | 63 | 63 | 63 | 63 | 63 | 62 | 62 | 63 | 63 | 63 | 63 | 63 | 62 | 62 | 63 | 63 | 63 | 63 | 63 | 62 | 62 | 63 | 63 | 63 | 63 | 63 | 62 | 62 |  | 430 |  | 450
R1-OBO
R2 | 27.5 | 38 | 41 | 27.5 | 27.5 | 27.5 | 27.5 | 27.5 | 38 | 41 | 27.5 | 27.5 | 27.5 | 27.5 | 27.5 | 38 | 41 | 27.5 | 27.5 | 27.5 | 27.5 | 27.5 | 38 | 41 | 27.5 | 27.5 | 27.5 | 27.5 | 27.5 | 38 | 41 |  | 210 |  | 230
R2-OBO
R3 | 62 | 60.5 | 62 | 62 | 62 | 62 | 62 | 62 | 60.5 | 62 | 62 | 62 | 62 | 62 | 62 | 60.5 | 62 | 62 | 62 | 62 | 62 | 62 | 60.5 | 62 | 62 | 62 | 62 | 62 | 62 | 60.5 | 62 |  | 430 |  | 450
R3-OBO
R4 | 53 | 54 | 54 | 53 | 53 | 53 | 53 | 53 | 54 | 54 | 53 | 53 | 53 | 53 | 53 | 54 | 54 | 53 | 53 | 53 | 53 | 53 | 54 | 54 | 53 | 53 | 53 | 53 | 53 | 54 | 54 |  | 370 |  | 390
R4-OBO
R5 | 34.5 | 53 | 53 | 34.5 | 34.5 | 34.5 | 34.5 | 34.5 | 53 | 53 | 34.5 | 34.5 | 34.5 | 34.5 | 34.5 | 53 | 53 | 34.5 | 34.5 | 34.5 | 34.5 | 34.5 | 53 | 53 | 34.5 | 34.5 | 34.5 | 34.5 | 34.5 | 53 | 53 |  | 270 |  | 290
R5-OBO
R6 | 40 | 48 | 48 | 40 | 40 | 40 | 40 | 40 | 48 | 48 | 40 | 40 | 40 | 40 | 40 | 48 | 48 | 40 | 40 | 40 | 40 | 40 | 48 | 48 | 40 | 40 | 40 | 40 | 40 | 48 | 48 |  | 290 |  | 310
R6-OBO
R7 | 64 | 62 | 62 | 64 | 64 | 64 | 64 | 64 | 62 | 62 | 64 | 64 | 64 | 64 | 64 | 62 | 62 | 64 | 64 | 64 | 64 | 64 | 62 | 62 | 64 | 64 | 64 | 64 | 64 | 62 | 62 |  | 430 |  | 450
R7-OBO
R8 | 26 | 39 | 39 | 26 | 26 | 26 | 26 | 26 | 39 | 39 | 26 | 26 | 26 | 26 | 26 | 39 | 39 | 26 | 26 | 26 | 26 | 26 | 39 | 39 | 26 | 26 | 26 | 26 | 26 | 39 | 39 |  | 190 |  | 210
R8-OBO
R9 | 65 | 64 | 64 | 65 | 65 | 65 | 65 | 65 | 64 | 64 | 65 | 65 | 65 | 65 | 65 | 64 | 64 | 65 | 65 | 65 | 65 | 65 | 64 | 64 | 65 | 65 | 65 | 65 | 65 | 64 | 64 |  | 450 |  | 470
R9-OBO
R10 | 58 | 63 | 63 | 58 | 58 | 58 | 58 | 58 | 63 | 63 | 58 | 58 | 58 | 58 | 58 | 63 | 63 | 58 | 58 | 58 | 58 | 58 | 63 | 63 | 58 | 58 | 58 | 58 | 58 | 63 | 63 |  | 410 |  | 430
R10-OBO
R11 | 55.5 | 61 | 61 | 54 | 54 | 54 | 54 | 55.5 | 61 | 61 | 54 | 54 | 54 | 54 | 55.5 | 61 | 61 | 54 | 54 | 54 | 54 | 55.5 | 61 | 61 | 54 | 54 | 54 | 54 | 55.5 | 61 | 61 |  | 390 |  | 410
R11-OBO
R12 | 63 | 61.5 | 61.5 | 63 | 63 | 63 | 63 | 63 | 61.5 | 61.5 | 63 | 63 | 63 | 63 | 63 | 61.5 | 61.5 | 63 | 63 | 63 | 63 | 63 | 61.5 | 61.5 | 63 | 63 | 63 | 63 | 63 | 61.5 | 61.5 |  | 430 |  | 450
R12-OBO
R13 | 48.5 | 49 | 49 | 48 | 48 | 48 | 48 | 48.5 | 49 | 49 | 48 | 48 | 48 | 48 | 48.5 | 49 | 49 | 48 | 48 | 48 | 48 | 48.5 | 49 | 49 | 48 | 48 | 48 | 48 | 48.5 | 49 | 49 |  | 330 |  | 350
R13-OBO
R14 | 26 | 40 | 40 | 26 | 26 | 26 | 26 | 26 | 40 | 40 | 26 | 26 | 26 | 26 | 26 | 40 | 40 | 26 | 26 | 26 | 26 | 26 | 40 | 40 | 26 | 26 | 26 | 26 | 26 | 40 | 40 |  | 210 |  | 230
R14-OBO
R15 | 73.5 | 64.5 | 64.5 | 73.5 | 73.5 | 73.5 | 73.5 | 73.5 | 64.5 | 64.5 | 73.5 | 73.5 | 73.5 | 73.5 | 73.5 | 64.5 | 64.5 | 73.5 | 73.5 | 73.5 | 73.5 | 73.5 | 64.5 | 64.5 | 73.5 | 73.5 | 73.5 | 73.5 | 73.5 | 64.5 | 64.5 |  | 490 |  | 510
R15-OBO
R16 | 22 | 35.5 | 34.5 | 21 | 21 | 21 | 21 | 22 | 35.5 | 34.5 | 21 | 21 | 21 | 21 | 22 | 35.5 | 34.5 | 21 | 21 | 21 | 21 | 22 | 35.5 | 34.5 | 21 | 21 | 21 | 21 | 22 | 35.5 | 34.5 |  | 170 |  | 190
R16-OBO
R17 | 18 | 24 | 24 | 18 | 18 | 18 | 18 | 18 | 24 | 24 | 18 | 18 | 18 | 18 | 18 | 24 | 24 | 18 | 18 | 18 | 18 | 18 | 24 | 24 | 18 | 18 | 18 | 18 | 18 | 24 | 24 |  | 130 |  | 150
R17-OBO
R18 | 42.5 | 62 | 62 | 42.5 | 42.5 | 42.5 | 42.5 | 42.5 | 62 | 62 | 42.5 | 42.5 | 42.5 | 42.5 | 42.5 | 62 | 62 | 42.5 | 42.5 | 42.5 | 42.5 | 42.5 | 62 | 62 | 42.5 | 42.5 | 42.5 | 42.5 | 42.5 | 62 | 62 |  | 330 |  | 350
R18-OBO
R19 | 34.5 | 48 | 48 | 34.5 | 34.5 | 34.5 | 34.5 | 34.5 | 48 | 48 | 34.5 | 34.5 | 34.5 | 34.5 | 34.5 | 48 | 48 | 34.5 | 34.5 | 34.5 | 34.5 | 34.5 | 48 | 48 | 34.5 | 34.5 | 34.5 | 34.5 | 34.5 | 48 | 48 |  | 250 |  | 270
R19-OBO
R20 | 32 | 40 | 40 | 25 | 25 | 25 | 25 | 32 | 40 | 40 | 25 | 25 | 25 | 25 | 32 | 40 | 40 | 25 | 25 | 25 | 25 | 32 | 40 | 40 | 25 | 25 | 25 | 25 | 32 | 40 | 40 |  | 210 |  | 230
R20-OBO
R21 | 27 | 40 | 40 | 26.5 | 26.5 | 26.5 | 26.5 | 27 | 40 | 40 | 26.5 | 26.5 | 26.5 | 26.5 | 27 | 40 | 40 | 26.5 | 26.5 | 26.5 | 26.5 | 27 | 40 | 40 | 26.5 | 26.5 | 26.5 | 26.5 | 27 | 40 | 40 |  | 210 |  | 230
R21-OBO
R22 | 60 | 61 | 59 | 58 | 58 | 58 | 58 | 60 | 61 | 59 | 58 | 58 | 58 | 58 | 60 | 61 | 59 | 58 | 58 | 58 | 58 | 60 | 61 | 59 | 58 | 58 | 58 | 58 | 60 | 61 | 59 |  | 410 |  | 430
R22-OBO
R23 | 58 | 64 | 64 | 58 | 58 | 58 | 58 | 58 | 64 | 64 | 58 | 58 | 58 | 58 | 58 | 64 | 64 | 58 | 58 | 58 | 58 | 58 | 64 | 64 | 58 | 58 | 58 | 58 | 58 | 64 | 64 |  | 410 |  | 430
R23-OBO
R25 | 42 | 48 | 48 | 41.5 | 41.5 | 41.5 | 41.5 | 42 | 48 | 48 | 41.5 | 41.5 | 41.5 | 41.5 | 42 | 48 | 48 | 41.5 | 41.5 | 41.5 | 41.5 | 42 | 48 | 48 | 41.5 | 41.5 | 41.5 | 41.5 | 42 | 48 | 48 |  | 290 |  | 310
R25-OBO
R26 | 48 | 61.5 | 61.5 | 41 | 41 | 41 | 41 | 48 | 61.5 | 61.5 | 41 | 41 | 41 | 41 | 48 | 61.5 | 61.5 | 41 | 41 | 41 | 41 | 48 | 61.5 | 61.5 | 41 | 41 | 41 | 41 | 48 | 61.5 | 61.5 |  | 330 |  | 350
R26-OBO
R27 | 36 | 48 | 48 | 35.5 | 35.5 | 35.5 | 35.5 | 36 | 48 | 48 | 35.5 | 35.5 | 35.5 | 35.5 | 36 | 48 | 48 | 35.5 | 35.5 | 35.5 | 35.5 | 36 | 48 | 48 | 35.5 | 35.5 | 35.5 | 35.5 | 36 | 48 | 48 |  | 270 |  | 290
R27-OBO
R28 | 41.5 | 64 | 62 | 41.5 | 41.5 | 41.5 | 41.5 | 41.5 | 64 | 62 | 41.5 | 41.5 | 41.5 | 41.5 | 41.5 | 64 | 62 | 41.5 | 41.5 | 41.5 | 41.5 | 41.5 | 64 | 62 | 41.5 | 41.5 | 41.5 | 41.5 | 41.5 | 64 | 62 |  | 330 |  | 350
R28-OBO
R29 | 42 | 61.5 | 62.5 | 43 | 45 | 45 | 43 | 42 | 61.5 | 62.5 | 43 | 45 | 45 | 43 | 42 | 61.5 | 62.5 | 43 | 45 | 45 | 43 | 42 | 61.5 | 62.5 | 43 | 45 | 45 | 43 | 42 | 61.5 | 62.5 |  | 330 |  | 350
R29-OBO
R30 | 56 | 62 | 62 | 56 | 56 | 56 | 56 | 56 | 62 | 62 | 56 | 56 | 56 | 56 | 56 | 62 | 62 | 56 | 56 | 56 | 56 | 56 | 62 | 62 | 56 | 56 | 56 | 56 | 56 | 62 | 62 |  | 390 |  | 410
R30-OBO
R31 | 43 | 62.5 | 62.5 | 43 | 43 | 43 | 43 | 43 | 62.5 | 62.5 | 43 | 43 | 43 | 43 | 43 | 62.5 | 62.5 | 43 | 43 | 43 | 43 | 43 | 62.5 | 62.5 | 43 | 43 | 43 | 43 | 43 | 62.5 | 62.5 |  | 330 |  | 350
R31-OBO
R32 | 26.5 | 41 | 40.5 | 26.5 | 26.5 | 26.5 | 26.5 | 26.5 | 41 | 40.5 | 26.5 | 26.5 | 26.5 | 26.5 | 26.5 | 41 | 40.5 | 26.5 | 26.5 | 26.5 | 26.5 | 26.5 | 41 | 40.5 | 26.5 | 26.5 | 26.5 | 26.5 | 26.5 | 41 | 40.5 |  | 210 |  | 230
R32-OBO
R33 | 37.5 | 54 | 54 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 54 | 54 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 54 | 54 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 54 | 54 | 37.5 | 37.5 | 37.5 | 37.5 | 37.5 | 54 | 54 |  | 290 |  | 310
R33-OBO
Totals
Billed @ a different Rate: