Spreadsheet: 752634d1634867954-count-number-of-hours-open-example
Sheet: sheet1

unit | sunday | monday | tuesday | wednesday | thursday | friday | saturday | Total |  |  |  |  | Count Number of Hours Open?
1 | 07:00AM-08:00PM | 07:00AM-08:00PM | 07:00AM-08:00PM | 07:00AM-08:00PM | 07:00AM-08:00PM | 07:00AM-08:00PM | 07:00AM-08:00PM |  |  |  |  |  | Hello:
2 | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-10:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM
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 |  |  |  |  |  | I receive operating hours in attached format. For example:
4 | 06:00AM-11:00PM | 06:00AM-11:00PM | 06:00AM-11:00PM | 06:00AM-11:00PM | 06:00AM-11:00PM | 06:00AM-12:00AM | 06:00AM-12:00AM |  |  |  |  |  | Location #1 is open Sundays from 7am to 8pm
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 |  |  |  |  |  | Location #3 is open from Sunday 7am until Monday 1am
6 | 06:00AM-04:00PM | 06:00AM-04:00PM | 06:00AM-10:00PM | 06:00AM-04:00PM | 06:00AM-04:00PM | 06:00AM-10:00PM | 06:00AM-04:00PM
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 |  |  |  |  |  | I need to count how many hours each location is open each week.
8 | 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 |  |  |  |  |  | Location #1 expected answer is 91
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 |  |  |  |  |  | Location #3 expected answer is 128
10 | 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
11 | 05:30AM-12:00AM | 05:30AM-12:00AM | 05:30AM-12:00AM | 05:30AM-12:00AM | 05:30AM-12:00AM | 05:30AM-02:30AM | 05:30AM-02:30AM |  |  |  |  |  | I haven't a clue how to start. [NAME] is appreciated. Using Excel 2013. Thank you.
12 | 07:00AM-10:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-04:00PM | 07:00AM-02:00PM
13 | 07:00AM-06:00PM | 07:00AM-06:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM
14 | 06:00AM-11:00PM | 06:00AM-11:00PM | 06:00AM-11:00PM | 06:00AM-11:00PM | 06:00AM-11:00PM | 06:00AM-11:00PM | 06:00AM-11:00PM
15 | 24 Hours | 06:00AM-01:00AM | 06:00AM-01:00AM | 06:00AM-01:00AM | 06:00AM-12:00AM | 24 Hours | 24 Hours
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
17 | 07:00AM-06:00PM | 06:00AM-10:00PM | 06:00AM-10:00PM | 06:00AM-10:00PM | 06:00AM-10:00PM | 06:00AM-11:00PM | 07:00AM-06:00PM
18 | 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
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
20 | 07:00am-03:00pm | 07:00am-03:00pm | 07:00am-03:00pm | 07:00am-01:30pm | 07:00am-02:00pm | 07:00am-02:00pm | 07:00am-03:00pm
21 | 07:00AM-03:00PM | 07:00AM-03:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-11:00PM | 07:00AM-03:00PM | 07:00AM-03:00PM
22 | 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
23 | 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
24 | 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