Spreadsheet: 148117d1333140682-conditional-formula-for-remainders-staffing-groups
Sheet: TEST

Monday
Staffing
Interval | Primary Group | Secondary Group | Primary Group Original | Secondary Group Original | Primary Group Using Secondary Group Staff | Secondary Group Staff Remaining | 0.8885714285714279 | Determine Primary & Secondary Group Staffing.  If Primary Group has negative staff, the use Secondary Group staff for that interval.  COLUMN F: Where D<0, D+E. If [NAME] then show remainder. If D+E≥0 then leave blank.  COLUMN G: Where D<0, D+E. If [NAME] then leave blank. If D+E≥0 then show remainder.  COLUMN B: If F is blank, use number in D divided by 2. If F is not blank, use number in F divided by 2.  COLUMN C: If G is blank, use number in E. If G is not blank, use number in G.
5:00 AM | 1.944285714285714 | 0.8885714285714279 | 3.888571428571428 |  |  | 0.8885714285714279
5:30 AM | 2.287142857142857 | 0.5742857142857147 | 4.574285714285715 |  |  | 0.5742857142857147
6:00 AM | 6.407142857142856 | 0.8142857142857114 | 12.81428571428571 | 1.022 |  | 0.8142857142857114
6:30 AM | 7.416428571428571 | 0.8328571428571419 | 14.83285714285714 | 1.35 |  | 0.8328571428571419
7:00 AM | 7.254285714285714 | 0.5085714285714289 | 14.50857142857143 | 2.061999999999999 |  | 0.5085714285714289
7:30 AM | 4.892142857142858 | 0.7842857142857156 | 9.784285714285716 | 1.888 |  | 0.7842857142857156
8:00 AM | 1.383142857142857 | 2.766285714285715 | -2.233714285714285 | 5 | 2.766285714285715 | 2.766285714285715
8:30 AM | -0.4024285714285707 | -0.8048571428571414 | -3.504857142857141 | 2.699999999999999 | -0.8048571428571414 | -0.8048571428571414
9:00 AM | 2.873285714285716 | 5.746571428571432 | -1.89142857142857 | 7.638000000000002 | 5.746571428571432 | 5.746571428571432
9:30 AM | 1.715928571428574 | 3.431857142857147 | -3.584142857142854 | 7.016000000000002 | 3.431857142857147 | 3.431857142857147
10:00 AM | 2.019857142857143 | 4.039714285714286 | -4.906285714285712 | 8.945999999999998 | 4.039714285714286 | 4.039714285714286
10:30 AM | 8.51857142857142 | 0.0371428571428396 | 17.03714285714284 | 7.490000000000002 |  | 0.0371428571428396
11:00 AM | 10.61857142857144 | 0.2371428571428709 | 21.23714285714287 | 9.564 |  | 0.2371428571428709
11:30 AM | 2.717142857142854 | 0.4342857142857071 | 5.434285714285707 | 9.82 |  | 0.4342857142857071
12:00 PM | 2.062142857142852 | 0.1242857142857048 | 4.124285714285705 | 11.592 |  | 0.1242857142857048
12:30 PM | 0.02971428571429158 | 0.05942857142858315 | -9.01857142857142 | 9.078000000000003 | 0.05942857142858315 | 0.05942857142858315
1:00 PM | 0.7185714285714297 | 0.4371428571428595 | 1.437142857142859 | 6.834000000000003 |  | 0.4371428571428595
1:30 PM | 5.204999999999998 | 0.4099999999999966 | 10.41 | 10.062 |  | 0.4099999999999966
2:00 PM | 8.824999999999989 | 0.6499999999999773 | 17.64999999999998 | 7.444000000000003 |  | 0.6499999999999773
2:30 PM | 3.376428571428562 | 0.752857142857124 | 6.752857142857124 | 12.296 |  | 0.752857142857124
3:00 PM | 0.7349999999999994 | 0.4699999999999989 | 1.469999999999999 | 12.306 |  | 0.4699999999999989
3:30 PM | 2.1642857142857 | 4.328571428571401 | -8.361428571428604 | 12.69 | 4.328571428571401 | 4.328571428571401
4:00 PM | -5.078428571428578 | -10.15685714285716 | -17.65285714285716 | 7.496000000000002 | -10.15685714285716 | -10.15685714285716
4:30 PM | -1.410428571428579 | -2.820857142857157 | -14.29285714285716 | 11.472 | -2.820857142857157 | -2.820857142857157
5:00 PM | 1.319428571428567 | 2.638857142857134 | -9.82714285714286 | 12.46599999999999 | 2.638857142857134 | 2.638857142857134
5:30 PM | -1.648000000000007 | -3.296000000000014 | -15.99000000000001 | 12.694 | -3.296000000000014 | -3.296000000000014
6:00 PM | -1.826285714285714 | -3.652571428571427 | -14.89857142857143 | 11.246 | -3.652571428571427 | -3.652571428571427
6:30 PM | -4.427714285714289 | -8.855428571428579 | -20.89142857142858 | 12.036 | -8.855428571428579 | -8.855428571428579
7:00 PM | -3.342714285714289 | -6.685428571428577 | -18.63142857142858 | 11.946 | -6.685428571428577 | -6.685428571428577
7:30 PM | -2.483000000000001 | -4.966000000000001 | -17.39 | 12.424 | -4.966000000000001 | -4.966000000000001
8:00 PM | 2.938714285714285 | 5.87742857142857 | -3.448571428571427 | 9.325999999999997 | 5.87742857142857 | 5.87742857142857
8:30 PM | 2.519571428571426 | 5.039142857142853 | -5.312857142857148 | 10.352 | 5.039142857142853 | 5.039142857142853
9:00 PM | 1.257142857142858 | 2.514285714285716 | -2.765714285714282 | 5.279999999999998 | 2.514285714285716 | 2.514285714285716
9:30 PM | 4.232714285714284 | 8.465428571428568 | -1.748571428571431 | 10.214 | 8.465428571428568 | 8.465428571428568
10:00 PM | 2.972142857142858 | 0.9442857142857157 | 5.944285714285716 | 3.735999999999999 |  | 0.9442857142857157
10:30 PM | 6.004999999999999 | 0.00999999999999801 | 12.01 | 4.521999999999999 |  | 0.00999999999999801