Spreadsheet: 215421d1361375431-help-with-hlookup-pallets-count-draft
Sheet: Sheet1

 |  |  |  | Day | # Pallets/Hr | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  | 2013-02-17 00:00:00 |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 2
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 3 | Receiving Capacity By Shift (Pallets per hour)
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 4 | Shift/Day |  |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 5 | 3rd Shift | 00:00:00 | 06:00:00 | 60 | 60 | 60 | 60 | 60 | 30 | 30
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 6 | 1st Shift | 06:01:00 | 14:00:00 | 30 | 60 | 60 | 60 | 60 | 60 | 30
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 7 | 2nd Shift | 14:01:00 | 22:00:00 | 30 | 60 | 60 | 60 | 60 | 60 | 30
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 8 | 3rd Shift | 22:01:00 | 23:59:00 | 60 | 60 | 60 | 60 | 60 | 30 | 30
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 9
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 10
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 11
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 12
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 13
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 14
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 15
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 16
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 17
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 18
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 19
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 20
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 21
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 22
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 23
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 24
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 25
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 26
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 27
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 28
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 29
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 30
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 31
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 32
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 33
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 34
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 35
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 36
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 37
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 38
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 39
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 40
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 41
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 42
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 43
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 44
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 45
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 46
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 47
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 48
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 49
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 50
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 51
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 52
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 53
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 54
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 55
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 56
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 57
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 58
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 59
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 60
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 61
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 62
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 63
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 64
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 65
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 66
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 67
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 68
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 69
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 70
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 71
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 72
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 73
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 74
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 75
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 76
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 77
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 78
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 79
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 80
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 81
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 82
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 83
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 84
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 85
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 86
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 87
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 88
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 89
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 90
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 91
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 92
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 93
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 94
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 95
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 96
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 97
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 98
 |  |  |  |  |  |  | 60 | 60 | 60 | 60 |  | 30 | 99