Spreadsheet: 684171d1593182188-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 | 52 |  |  |  |  |  |  |  |  |  |  |  | 2017-02-16 00:00:00 | 1 | 52
 |  | 2017-02-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-17 00:00:00 | 0 | #[NAME]!
 |  | 2017-02-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-18 00:00:00 | 0 | #[NAME]!
 |  | 2017-02-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-19 00:00:00 | 0 | #[NAME]!
 |  | 2017-02-20 00:00:00 | Yes |  |  |  |  |  |  |  |  |  |  |  |  | 2017-02-20 00:00:00 | 0 | #[NAME]!