Spreadsheet: 720583d1614197283-formula-to-alter-calculation-dependant-on-drop-down-list-value-copy-of-tim-recording-sheet-1-
Sheet: WEEK 1

 | Monday | Minute |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday Calculations
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Count
 | 6 | C1,C1,c1 | C1,C3, c2 | C3,C3 | C1,C2, C1 | c1 c3 c2 | C2 c2 |  |  |  |  |  |  |  |  |  |  | Day you're Interested in |  |  | Monday |  |  |  | Number of instances of C1 for 06:00 - 07:00
 | 7 | C1,C1,C1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of instances of C2 for 06:00 - 07:00
 | 8 | C1,C2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Description |  |  | Number of instances of C3 for 06:00 - 07:00
 | 9 | C3, c5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Code you're interested in: |  |  | C1 |  |  |  | Total codes for 06:00 - 07:00
 | 10 | C1, C1, C1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time you're interested in: |  |  | 07:00 - 07:59
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of instances of C1 for 06:00 - 06:10
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Instances for the Hour |  |  |  |  |  |  | Number of instances of C1 for 07:00 - 07:10
 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Instances for the Day |  |  |  |  |  |  | Number of instances of C1 for 08:00 - 08:10
 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :00 |  |  |  |  | Number of instances of C1 for 09:00 - 09:10
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :10 |  |  |  |  | Number of instances of C1 for 10:00 - 10:10
 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :20 |  |  |  |  | Number of instances of C1 for 11:00 - 11:10
 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :30 |  |  |  |  | Number of instances of C1 for 12:00 - 12:10
 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :40 |  |  |  |  | Number of instances of C1 for 13:00 - 13:10
 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :50 |  |  |  |  | Number of instances of C1 for 14:00 - 14:10
 | Tuesday | Minute |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of instances of C1 for 15:00 - 15:10
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of instances of C1 for 16:00 - 16:10
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of instances of C1 for 17:00 - 17:10
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of instances of C1 for 18:00 - 18:10
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of instances of C1 for 19:00 - 19:10
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | Wednesday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | Thursday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | Friday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19