Spreadsheet: 772246d1647104623-count-number-of-hours-open-new-example
Sheet: sheet1

unit | sunday | monday | tuesday | wednesday | thursday | friday | saturday | Result | Expected Result | Expected Result
1 | 07:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-02:00AM | 07:00AM-02:00AM |  | 5.333333333333334
2 | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM |  | 4.666666666666668
3 | 07:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-02:00AM | 07:00AM-02:00AM |  | 5.333333333333334
4 | 06:00AM-03:00PM | 06:00AM-03:00PM | 06:00AM-03:00PM | 06:00AM-03:00PM | 06:00AM-11:00PM | 06:00AM-11:00PM | 06:00AM-11:00PM |  | 3.625
5 | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-12:00AM | 07:00AM-12:00AM |  | 4.75
6 | 05:00AM-04:00PM | 05:00AM-04:00PM | 05:00AM-04:00PM | 05:00AM-09:00PM | 05:00AM-09:00PM | 05:00AM-09:00PM | 05:00AM-04:00PM |  | 3.833333333333333
7 | 06:30AM-12:00AM | 06:30AM-12:00AM | 06:30AM-12:00AM | 06:30AM-12:00AM | 06:30AM-12:00AM | 06:30AM-01:00AM | 06:30AM-01:00AM |  | 5.1875
8 | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM |  | 2.625
9 | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM |  | 5.25
10 | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM |  | 5.25
11 | 24 Hours | 05:30AM-12:00AM | 05:30AM-12:00AM | 05:30AM-12:00AM | 05:30AM-12:00AM | 24 Hours | 24 Hours |  | 6.083333333333334
12 | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM |  | 2.625
13 | 07:00AM-08:00PM | 07:00AM-08:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM |  | 4.416666666666668
14 | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM |  | 5.25
15 | 24 Hours | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 24 Hours | 24 Hours |  | 6
16 | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-12:00AM | 06:00AM-01:00AM | 06:00AM-01:00AM |  | 5.333333333333334
17 | 06:00AM-08:00PM | 06:00AM-10:00PM | 06:00AM-10:00PM | 06:00AM-10:00PM | 06:00AM-10:00PM | 06:00AM-11:00PM | 06:00AM-08:00PM |  | 4.541666666666666
18 | 06:30AM-12:00AM | 06:00AM-12:30AM | 06:00AM-12:30AM | 06:30AM-12:00AM | 06:30AM-12:00AM | 06:30AM-01:00AM | 06:30AM-01:00AM |  | 5.270833333333333
19 | 07:00AM-03:00PM | 07:00AM-03:00PM | 07:00AM-03:00PM | 07:00AM-03:00PM | 07:00AM-03:00PM | 07:00AM-03:00PM | 07:00AM-03:00PM |  | 2.333333333333333
20 | 07:00am-03:00pm | 07:00am-03:00pm | 07:00am-03:00pm | 07:00am-03:00pm | 07:00am-05:00pm | 07:00am-05:00pm | 07:00am-05:00pm |  | 2.583333333333333
21 | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM |  | 4.666666666666668
22 | 12:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-12:00AM | 24 Hours |  | 5.333333333333334
23 | 24 Hours | 24 Hours | 24 Hours | 24 Hours | 24 Hours | 24 Hours | 24 Hours |  | 7
24 | 12:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-01:00AM | 07:00AM-12:00AM | 24 Hours |  | 4.75 | 138