Spreadsheet: 684113d1593152087-formula-to-expand-retract-table-b-according-to-entry-actions-on-table-a-logged
Sheet: TimeOut

TO # | Weekday | Date | Present | Dur1 | Dur2 | Dur3 | Dur4 | Dur5 | Dur6 | Dur7 | Dur8 | Dur9 | Dur10 |  |  | Date | Time Outs | Average
 |  | 2017-01-01 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  | 2017-01-02 00:00:00 | Yes | 34 | 47 | 56 | 22 | 11 | 6 | 33 | 53 |  |  |  |  | 2017-01-02 00:00:00 | 8 | 32.75
 |  | 2017-01-03 00:00:00 | Yes | 26 |  |  |  |  |  |  |  |  |  |  |  | 2017-01-03 00:00:00 | 1 | 26
 |  | 2017-01-04 00:00:00 | Yes | 34 |  |  |  |  |  |  |  |  |  |  |  | 2017-01-04 00:00:00 | 1 | 34
 |  | 2017-01-05 00:00:00 | Yes | 22 | 25 | 27 |  |  |  |  |  |  |  |  |  | 2017-01-05 00:00:00 | 3 | 24.66666666666667
 |  | 2017-01-06 00:00:00 | Yes | 15 | 21 | 31 |  |  |  |  |  |  |  |  |  | 2017-01-06 00:00:00 | 3 | 22.33333333333333
 |  | 2017-01-07 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-07 00:00:00 | #N/A | #N/A
 |  | 2017-01-08 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-08 00:00:00 | #N/A | #N/A
 |  | 2017-01-09 00:00:00 | Yes | 32 | 23 | 10 | 24 | 23 | 34 |  |  |  |  |  |  | 2017-01-09 00:00:00 | 6 | 24.33333333333333
 |  | 2017-01-10 00:00:00 | Yes | 23 | 25 |  |  |  |  |  |  |  |  |  |  | 2017-01-10 00:00:00 | 2 | 24
 |  | 2017-01-11 00:00:00 | Yes | 34 | 56 | 34 | 21 | 24 | 36 |  |  |  |  |  |  | 2017-01-11 00:00:00 | 6 | 34.16666666666666
 |  | 2017-01-12 00:00:00 | Yes | 22 |  |  |  |  |  |  |  |  |  |  |  | 2017-01-12 00:00:00 | 1 | 22
 |  | 2017-01-13 00:00:00 | Yes | 24 | 30 | 26 | 14 |  |  |  |  |  |  |  |  | 2017-01-13 00:00:00 | 4 | 23.5
 |  | 2017-01-14 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-14 00:00:00 | #N/A | #N/A
 |  | 2017-01-15 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-15 00:00:00 | #N/A | #N/A
 |  | 2017-01-16 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-16 00:00:00 | #N/A | #N/A
 |  | 2017-01-17 00:00:00 | Yes | 24 | 14 | 28 | 34 | 16 | 18 | 13 | 13 |  |  |  |  | 2017-01-17 00:00:00 | 8 | 20
 |  | 2017-01-18 00:00:00 | Yes | 24 |  |  |  |  |  |  |  |  |  |  |  | 2017-01-18 00:00:00 | 1 | 24
 |  | 2017-01-19 00:00:00 | Yes | 16 |  |  |  |  |  |  |  |  |  |  |  | 2017-01-19 00:00:00 | 1 | 16
 |  | 2017-01-20 00:00:00 | Yes | 28 | 34 | 16 | 18 |  |  |  |  |  |  |  |  | 2017-01-20 00:00:00 | 4 | 24
 |  | 2017-01-21 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-21 00:00:00 | #N/A | #N/A
 |  | 2017-01-22 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-22 00:00:00 | #N/A | #N/A
 |  | 2017-01-23 00:00:00 | Yes | 10 | 24 | 23 | 34 |  |  |  |  |  |  |  |  | 2017-01-23 00:00:00 | 4 | 22.75
 |  | 2017-01-24 00:00:00 | Yes | 10 | 24 | 23 |  |  |  |  |  |  |  |  |  | 2017-01-24 00:00:00 | 3 | 19
 |  | 2017-01-25 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-25 00:00:00 | #N/A | #N/A
 |  | 2017-01-26 00:00:00 | Yes | 22 | 12 | 14 |  |  |  |  |  |  |  |  |  | 2017-01-26 00:00:00 | 3 | 16
 |  | 2017-01-27 00:00:00 | Yes | 22 | 12 |  |  |  |  |  |  |  |  |  |  | 2017-01-27 00:00:00 | 2 | 17
 |  | 2017-01-28 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-28 00:00:00 | #N/A | #N/A
 |  | 2017-01-29 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-29 00:00:00 | #N/A | #N/A
 |  | 2017-01-30 00:00:00 | Yes | 12 | 14 | 17 |  |  |  |  |  |  |  |  |  | 2017-01-30 00:00:00 | 3 | 14.33333333333333
 |  | 2017-01-31 00:00:00 | Yes | 13 | 14 | 15 |  |  |  |  |  |  |  |  |  | 2017-01-31 00:00:00 | 3 | 14
 |  | 2017-02-01 00:00:00 | Yes | 16 | 17 |  |  |  |  |  |  |  |  |  |  | 2017-02-01 00:00:00 | 2 | 16.5
 |  | 2017-02-02 00:00:00 | Yes | 18 | 19 |  |  |  |  |  |  |  |  |  |  | 2017-02-02 00:00:00 | 2 | 18.5
 |  | 2017-02-03 00:00:00 | Yes | 20 | 21 |  |  |  |  |  |  |  |  |  |  | 2017-02-03 00:00:00 | 2 | 20.5
 |  | 2017-02-04 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-04 00:00:00 | #N/A | #N/A
 |  | 2017-02-05 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-05 00:00:00 | #N/A | #N/A
 |  | 2017-02-06 00:00:00 | Yes | 22 | 23 |  |  |  |  |  |  |  |  |  |  | 2017-02-06 00:00:00 | 2 | 22.5
 |  | 2017-02-07 00:00:00 | Yes | 24 |  |  |  |  |  |  |  |  |  |  |  | 2017-02-07 00:00:00 | 1 | 24
 |  | 2017-02-08 00:00:00 | Yes | 25 | 26 | 27 |  |  |  |  |  |  |  |  |  | 2017-02-08 00:00:00 | 3 | 26
 |  | 2017-02-09 00:00:00 | Yes | 28 |  |  |  |  |  |  |  |  |  |  |  | 2017-02-09 00:00:00 | 1 | 28
 |  | 2017-02-10 00:00:00 | Yes | 29 | 30 | 31 |  |  |  |  |  |  |  |  |  | 2017-02-10 00:00:00 | 3 | 30
 |  | 2017-02-11 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-11 00:00:00 | #N/A | #N/A
 |  | 2017-02-12 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-12 00:00:00 | #N/A | #N/A
 |  | 2017-02-13 00:00:00 | Yes | 19 | 23 |  |  |  |  |  |  |  |  |  |  | 2017-02-13 00:00:00 | 2 | 21
 |  | 2017-02-14 00:00:00 | Yes | 29 | 65 |  |  |  |  |  |  |  |  |  |  | 2017-02-14 00:00:00 | 2 | 47
 |  | 2017-02-15 00:00:00 | Yes | 66 |  |  |  |  |  |  |  |  |  |  |  | 2017-02-15 00:00:00 | 1 | 66
 |  | 2017-02-16 00:00:00 | Yes | 67 |  |  |  |  |  |  |  |  |  |  |  | 2017-02-16 00:00:00 | 1 | 67
 |  | 2017-02-17 00:00:00 | Yes | 68 |  |  |  |  |  |  |  |  |  |  |  | 2017-02-17 00:00:00 | 1 | 68
 |  | 2017-02-18 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-18 00:00:00 | #N/A | #N/A
 |  | 2017-02-19 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-19 00:00:00 | #N/A | #N/A
 |  | 2017-02-20 00:00:00 | Yes | 69 |  |  |  |  |  |  |  |  |  |  |  | 2017-02-20 00:00:00 | 1 | 69
 |  | 2017-02-21 00:00:00 | Yes | 70 |  |  |  |  |  |  |  |  |  |  |  | 2017-02-21 00:00:00 | 1 | 70
 |  | 2017-02-22 00:00:00 | Yes | 71 | 72 |  |  |  |  |  |  |  |  |  |  | 2017-02-22 00:00:00 | 2 | 71.5
 |  | 2017-02-23 00:00:00 | Yes | 73 | 72 |  |  |  |  |  |  |  |  |  |  | 2017-02-23 00:00:00 | 2 | 72.5
 |  | 2017-02-24 00:00:00 | Yes | 75 |  |  |  |  |  |  |  |  |  |  |  | 2017-02-24 00:00:00 | 1 | 75
 |  | 2017-02-25 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-25 00:00:00 | #N/A | #N/A
 |  | 2017-02-26 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-26 00:00:00 | #N/A | #N/A
 |  | 2017-02-27 00:00:00 | Yes | 76 |  |  |  |  |  |  |  |  |  |  |  | 2017-02-27 00:00:00 | 1 | 76
 |  | 2017-02-28 00:00:00 | Yes | 77 | 78 |  |  |  |  |  |  |  |  |  |  | 2017-02-28 00:00:00 | 2 | 77.5
 |  | 2017-03-01 00:00:00 | Yes | 79 |  |  |  |  |  |  |  |  |  |  |  | 2017-03-01 00:00:00 | 1 | 79
 |  | 2017-03-02 00:00:00 | Yes | 80 |  |  |  |  |  |  |  |  |  |  |  | 2017-03-02 00:00:00 | 1 | 80
 |  | 2017-03-03 00:00:00 | Yes | 81 |  |  |  |  |  |  |  |  |  |  |  | 2017-03-03 00:00:00 | 1 | 81
 |  | 2017-03-04 00:00:00 | No |  |  |  |  |  |  |  |  |  |  |  |  | 2017-03-04 00:00:00 | #N/A | #N/A
 |  | 2017-03-05 00:00:00 | No | 23 |  |  |  |  |  |  |  |  |  |  |  | 2017-03-05 00:00:00 | #N/A | #N/A
 |  | 2017-03-06 00:00:00 | Yes | 25 |  |  |  |  |  |  |  |  |  |  |  | 2017-03-06 00:00:00 | 1 | 25
 |  |  |  |  |  | INDEX(TimeOut!toTable[Present],MATCH(D1,TimeOut!toTable[Present],0)+1,1)
 |  |  |  |  |  | HYPERLINK("#"&CELL("address",INDEX(Summary!B2:B32,MATCH(A3,Summary!B2:B33,0))),"Jump to the data cell")
 |  |  |  |  |  | HYPERLINK("#"&CELL("address",INDEX(TimeOut!toTable[Present],MATCH(A3,TimeOut!toTable[Present],0))),"Jump to TimeOut")
 |  |  |  |  |  | INDEX(toTable[Date],COUNTA(toTable[Date]))
 |  |  |  |  |  | HYPERLINK(REPLACE(CELL("filename"),1,FIND("[",CELL("filename")),"[")&"!C"&MAX(MATCH(0,C:C,-1),MATCH(CHAR(255),C:C,1))+1,"HYPERLINK")