Spreadsheet: 480437d1473915034-conditional-formatting-using-numbers-symbols-and-string-text-sheet1
Sheet: Sheet1

 | Hours | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
1 |  | 2016-07-25 00:00:00 | 2016-07-26 00:00:00 | 2016-07-27 00:00:00 | 2016-07-28 00:00:00 | 2016-07-29 00:00:00 | 2016-07-30 00:00:00 | 2016-07-31 00:00:00
 | 9am-1pm |  |  |  |  | 25
 | 1pm-5pm |  |  |  | 27 |  |  |  |  | formulas to go in sections according to the hours only
 | 1pm-5pm |  |  |  | 26
2 |  | 2016-08-01 00:00:00 | 2016-08-02 00:00:00 | 2016-08-03 00:00:00 | 2016-08-04 00:00:00 | 2016-08-05 00:00:00 | 2016-08-06 00:00:00 | 2016-08-07 00:00:00
 | 9am-1pm |  |  |  |  | 26
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 25
3 |  | 2016-08-08 00:00:00 | 2016-08-09 00:00:00 | 2016-08-10 00:00:00 | 2016-08-11 00:00:00 | 2016-08-12 00:00:00 | 2016-08-13 00:00:00 | 2016-08-14 00:00:00
 | 9am-1pm |  |  |  |  | 25
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 26
4 |  | 2016-08-15 00:00:00 | 2016-08-16 00:00:00 | 2016-08-17 00:00:00 | 2016-08-18 00:00:00 | 2016-08-19 00:00:00 | 2016-08-20 00:00:00 | 2016-08-21 00:00:00
 | 9am-1pm |  |  |  |  | 26
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 25
5 |  | 2016-08-22 00:00:00 | 2016-08-23 00:00:00 | 2016-08-24 00:00:00 | 2016-08-25 00:00:00 | 2016-08-26 00:00:00 | 2016-08-27 00:00:00 | 2016-08-28 00:00:00
 | 9am-1pm |  |  |  |  | 25
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 26
6 |  | 2016-08-29 00:00:00 | 2016-08-30 00:00:00 | 2016-08-31 00:00:00 | 2016-09-01 00:00:00 | 2016-09-02 00:00:00 | 2016-09-03 00:00:00 | 2016-09-04 00:00:00
 | 9am-1pm |  |  |  |  | 28
 | 9am-1pm |  |  |  |  | 26
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 25
7 |  | 2016-09-05 00:00:00 | 2016-09-06 00:00:00 | 2016-09-07 00:00:00 | 2016-09-08 00:00:00 | 2016-09-09 00:00:00 | 2016-09-10 00:00:00 | 2016-09-11 00:00:00
 | 9am-1pm |  |  |  |  | 28
 | 9am-1pm |  |  |  |  | 25
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 26
8 |  | 2016-09-12 00:00:00 | 2016-09-13 00:00:00 | 2016-09-14 00:00:00 | 2016-09-15 00:00:00 | 2016-09-16 00:00:00 | 2016-09-17 00:00:00 | 2016-09-18 00:00:00
 | 9am-1pm
 | 9am-1pm |  |  |  |  | 26
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 25 + 28
9 |  | 2016-09-19 00:00:00 | 2016-09-20 00:00:00 | 2016-09-21 00:00:00 | 2016-09-22 00:00:00 | 2016-09-23 00:00:00 | 2016-09-24 00:00:00 | 2016-09-25 00:00:00
 | 9am-1pm |  |  |  |  | 28
 | 9am-1pm |  |  |  |  | 25
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 26
holiday |  | 2016-09-26 00:00:00 | 2016-09-27 00:00:00 | 2016-09-28 00:00:00 | 2016-09-29 00:00:00 | 2016-09-30 00:00:00 | 2016-10-01 00:00:00 | 2016-10-02 00:00:00
 | 9am-1pm |  |  |  |  | 28
 | 9am-1pm |  |  |  |  | 26
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 25
10 |  | 2016-10-03 00:00:00 | 2016-10-04 00:00:00 | 2016-10-05 00:00:00 | 2016-10-06 00:00:00 | 2016-10-07 00:00:00 | 2016-10-08 00:00:00 | 2016-10-09 00:00:00
 | 9am-1pm |  |  |  |  | 28
 | 9am-1pm |  |  |  |  | 25
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 26
11 |  | 2016-10-10 00:00:00 | 2016-10-11 00:00:00 | 2016-10-12 00:00:00 | 2016-10-13 00:00:00 | 2016-10-14 00:00:00 | 2016-10-15 00:00:00 | 2016-10-16 00:00:00
 | 9am-1pm |  |  |  |  | 28
 | 9am-1pm |  |  |  |  | 26
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 25
12 |  | 2016-10-17 00:00:00 | 2016-10-18 00:00:00 | 2016-10-19 00:00:00 | 2016-10-20 00:00:00 | 2016-10-21 00:00:00 | 2016-10-22 00:00:00 | 2016-10-23 00:00:00
 | 9am-1pm |  |  |  |  | 28
 | 9am-1pm |  |  |  |  | 25
 | 1pm-5pm |  |  |  | 27
 | 1pm-5pm |  |  |  | 26
 |  | 2016-10-24 00:00:00 | 2016-10-25 00:00:00 | 2016-10-26 00:00:00 | 2016-10-27 00:00:00 | 2016-10-28 00:00:00 | 2016-10-29 00:00:00 | 2016-10-30 00:00:00
 | 9am-1pm
 | 1pm-5pm
 |  | 2016-10-31 00:00:00 | 2016-11-01 00:00:00 | 2016-11-02 00:00:00 | 2016-11-03 00:00:00 | 2016-11-04 00:00:00 | 2016-11-05 00:00:00 | 2016-11-06 00:00:00
 | 9am-1pm
 | 1pm-5pm
 |  | 2016-11-07 00:00:00 | 2016-11-08 00:00:00 | 2016-11-09 00:00:00 | 2016-11-10 00:00:00 | 2016-11-11 00:00:00 | 2016-11-12 00:00:00 | 2016-11-13 00:00:00
 | 9am-1pm
 | 1pm-5pm
 |  | 2016-11-14 00:00:00 | 2016-11-15 00:00:00 | 2016-11-16 00:00:00 | 2016-11-17 00:00:00 | 2016-11-18 00:00:00 | 2016-11-19 00:00:00 | 2016-11-20 00:00:00
 | 9am-1pm
 | 1pm-5pm
 |  | 2016-11-21 00:00:00 | 2016-11-22 00:00:00 | 2016-11-23 00:00:00 | 2016-11-24 00:00:00 | 2016-11-25 00:00:00 | 2016-11-26 00:00:00 | 2016-11-27 00:00:00
 | 9am-1pm
 | 1pm-5pm
 |  | 2016-11-28 00:00:00 | 2016-11-29 00:00:00 | 2016-11-30 00:00:00 | 2016-12-01 00:00:00 | 2016-12-02 00:00:00 | 2016-12-03 00:00:00 | 2016-12-04 00:00:00
 | 9am-1pm
 | 1pm-5pm
 |  | 2016-12-05 00:00:00 | 2016-12-06 00:00:00 | 2016-12-07 00:00:00 | 2016-12-08 00:00:00 | 2016-12-09 00:00:00 | 2016-12-10 00:00:00 | 2016-12-11 00:00:00
 | 9am-1pm
 | 1pm-5pm