Spreadsheet: 684108d1593145069-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
 |  | 2017-01-02 00:00:00 | Yes | 34 | 47 | 56 | 22 | 11 | 6 | 33 | 53
 |  | 2017-01-03 00:00:00 | Yes | 26
 |  | 2017-01-04 00:00:00 | Yes | 34
 |  | 2017-01-05 00:00:00 | Yes | 22 | 25 | 27
 |  | 2017-01-06 00:00:00 | Yes | 15 | 21 | 31
 |  | 2017-01-07 00:00:00 | No
 |  | 2017-01-08 00:00:00 | No
 |  | 2017-01-09 00:00:00 | Yes | 32 | 23 | 10 | 24 | 23 | 34
 |  | 2017-01-10 00:00:00 | Yes | 23 | 25
 |  | 2017-01-11 00:00:00 | Yes | 34 | 56 | 34 | 21 | 24 | 36
 |  | 2017-01-12 00:00:00 | Yes | 22
 |  | 2017-01-13 00:00:00 | Yes | 24 | 30 | 26 | 14
 |  | 2017-01-14 00:00:00 | No
 |  | 2017-01-15 00:00:00 | No
 |  | 2017-01-16 00:00:00 | No
 |  | 2017-01-17 00:00:00 | Yes | 24 | 14 | 28 | 34 | 16 | 18 | 13 | 13
 |  | 2017-01-18 00:00:00 | Yes | 24
 |  | 2017-01-19 00:00:00 | Yes | 16
 |  | 2017-01-20 00:00:00 | Yes | 28 | 34 | 16 | 18
 |  | 2017-01-21 00:00:00 | No
 |  | 2017-01-22 00:00:00 | No
 |  | 2017-01-23 00:00:00 | Yes | 10 | 24 | 23 | 34
 |  | 2017-01-24 00:00:00 | Yes | 10 | 24 | 23
 |  | 2017-01-25 00:00:00 | No
 |  | 2017-01-26 00:00:00 | Yes | 22 | 12 | 14
 |  | 2017-01-27 00:00:00 | Yes | 22 | 12
 |  | 2017-01-28 00:00:00 | No
 |  | 2017-01-29 00:00:00 | No
 |  | 2017-01-30 00:00:00 | Yes | 12 | 14 | 17
 |  | 2017-01-31 00:00:00 | Yes | 13 | 14 | 15
 |  | 2017-02-01 00:00:00 | Yes | 16 | 17
 |  | 2017-02-02 00:00:00 | Yes | 18 | 19
 |  | 2017-02-03 00:00:00 | Yes | 20 | 21
 |  | 2017-02-04 00:00:00 | No
 |  | 2017-02-05 00:00:00 | No
 |  | 2017-02-06 00:00:00 | Yes | 22 | 23
 |  | 2017-02-07 00:00:00 | Yes | 24
 |  | 2017-02-08 00:00:00 | Yes | 25 | 26 | 27
 |  | 2017-02-09 00:00:00 | Yes | 28
 |  | 2017-02-10 00:00:00 | Yes | 29 | 30 | 31
 |  | 2017-02-11 00:00:00 | No
 |  | 2017-02-12 00:00:00 | No
 |  | 2017-02-13 00:00:00 | Yes | 19 | 23
 |  | 2017-02-14 00:00:00 | Yes | 29 | 65
 |  | 2017-02-15 00:00:00 | Yes | 66
 |  | 2017-02-16 00:00:00 | Yes | 67
 |  | 2017-02-17 00:00:00 | Yes | 68
 |  | 2017-02-18 00:00:00 | No
 |  | 2017-02-19 00:00:00 | No
 |  | 2017-02-20 00:00:00 | Yes | 69
 |  | 2017-02-21 00:00:00 | Yes | 70
 |  | 2017-02-22 00:00:00 | Yes | 71 | 72
 |  | 2017-02-23 00:00:00 | Yes | 73 | 72
 |  | 2017-02-24 00:00:00 | Yes | 75
 |  | 2017-02-25 00:00:00 | No
 |  | 2017-02-26 00:00:00 | No
 |  | 2017-02-27 00:00:00 | Yes | 76
 |  | 2017-02-28 00:00:00 | Yes | 77 | 78
 |  | 2017-03-01 00:00:00 | Yes | 79
 |  | 2017-03-02 00:00:00 | Yes | 80
 |  | 2017-03-03 00:00:00 | Yes | 81
 |  | 2017-03-04 00:00:00 | No
 |  | 2017-03-05 00:00:00 | No | 23
 |  | 2017-03-06 00:00:00 | Yes | 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")