Spreadsheet: 137404d1327091018-countif-not-returning-expected-result-countif
Sheet: Staff Sched-Clean

 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Description |  |  |  |  |  |  |  |  | Sunday | Time of Day | [NAME] | Actual Staffing |  |  | 7;00am-7;30pm
Tech | 7;00am-7;30pm | 7:00am-5:30pm | 7:30am-4:00pm | 7:00am-7:30pm | 7:00am-7:30pm | 7:00am-7:30pm | 7;00am-7;30pm |  |  | 1900-01-01 00:00:00 | 8.25 |  |  |  | 7:00am-3:30pm
Tech | 7;00am-7;30pm | 7:00am-5:30pm | 7:00am-5:30pm | 7:00am-7:30pm | 7:00am-5:30pm | 7:00am-5:30pm | 7;00am-7;30pm |  |  | 1900-01-01 01:00:00 | 10.28 |  |  |  | 3p-7p
Tech |  | 7:00am-3:30pm | 7:00am-7:30pm | 7:00am-5:30pm | 7:00am-3:30pm | 7:00am-7:30pm |  |  |  | 1900-01-01 02:00:00 | 8.833333333333334 |  |  |  | 7:30am-4:00pm
Tech |  |  |  |  |  |  |  |  |  | 1900-01-01 03:00:00 | 9.434782608695652 |  |  |  | 7:00am-5:30pm
Tech |  | 7;00am-5;30pm | 7;00am-5;30pm | 7;00am-5;30pm | 7;00am-5;30pm | 7;00am-5;30pm |  |  |  | 1900-01-01 04:00:00 | 13.23076923076923 |  |  |  | 7;00pm-7;30am
Tech |  | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-7;30pm |  |  |  | 1900-01-01 05:00:00 | 20.03846153846154
[NAME] |  | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm |  |  |  | 1900-01-01 06:00:00 | 10.69230769230769
Tech |  | 7;00am-3;30pm | 7;00am-3;30pm | 7;00am-3;30pm | 7;00am-3;30pm | 7;00am-3;30pm |  |  |  | 1900-01-01 07:00:00 | 8.862068965517242 | 2
Tech |  | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-7;30pm |  |  |  | 1900-01-01 08:00:00 | 19.78787878787879 | 1
Tech | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-5;30pm | 7;00am-5;30pm | 7;00am-5;30pm | 7;00am-5;30pm | 7;00am-7;30pm |  |  | 1900-01-01 09:00:00 | 24.875 | 1
Tech | 7;00pm-7;30am | 3p-7p | 3p-7p | 3p-7p | 3p-7p | 3p-7p | 7;00pm-7;30am |  |  | 1900-01-01 10:00:00 | 17.62222222222222 | 1
Tech |  | 7;00pm-7;30am | 7;00pm-7;30am | 7;00pm-7;30am | 7;00pm-7;30am | 7;00pm-7;30am |  |  |  | 1900-01-01 11:00:00 | 17.20930232558139 | 1
Tech | 7;00pm-7;30am | 7;00pm-7;30am | 7;00pm-7;30am | 7;00pm-7;30am | 7;00pm-7;30am | 7;00pm-7;30am | 7;00pm-7;30am |  |  | 1900-01-01 12:00:00 | 13.93333333333333 | 1
Tech | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-7;30pm | 7;00am-7;30pm |  |  | 1900-01-01 13:00:00 | 11.44897959183673 | 1
Tech | 7;00am-7;30pm | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm | 7:30am-4:00pm | 7;00am-7;30pm |  |  | 1900-01-01 14:00:00 | 12.76595744680851 | 1
 |  |  |  |  |  |  |  |  |  | 1900-01-01 15:00:00 | 16.36585365853659 | 1
 |  |  |  |  |  |  |  |  |  | 1900-01-01 16:00:00 | 14.71794871794872 | 1
 |  |  |  |  |  |  |  |  |  | 1900-01-01 17:00:00 | 13.8 | 1
 |  |  |  |  |  |  |  |  |  | 1900-01-01 18:00:00 | 12.71052631578947 | 1
 |  |  |  |  |  |  |  |  |  | 1900-01-01 19:00:00 | 12.70967741935484 | 2.5
 |  |  |  |  |  |  |  |  |  | 1900-01-01 20:00:00 | 13.25925925925926 | 2
 |  |  |  |  |  |  |  |  |  | 1900-01-01 21:00:00 | 12.41379310344828 | 2
 |  |  |  |  |  |  |  |  |  | 1900-01-01 22:00:00 | 11.23333333333333 | 2
 |  |  |  |  |  |  |  |  |  | 1900-01-01 23:00:00 | 8.73076923076923 | 2