Spreadsheet: 745852d1630323483-how-do-i-extract-a-value-if-another-cell-is-true-consumption
Sheet: consumption

 | Start | End
0.106 | 2021-07-02T00:00:00+01:00 | 2021-07-02T00:30:00+01:00 | T00:00
0.407 | 2021-07-02T00:30:00+01:00 | 2021-07-02T01:00:00+01:00 | T00:30
0.181 | 2021-07-02T01:00:00+01:00 | 2021-07-02T01:30:00+01:00
0.447 | 2021-07-02T01:30:00+01:00 | 2021-07-02T02:00:00+01:00
0.119 | 2021-07-02T02:00:00+01:00 | 2021-07-02T02:30:00+01:00
0.098 | 2021-07-02T02:30:00+01:00 | 2021-07-02T03:00:00+01:00
0.114 | 2021-07-02T03:00:00+01:00 | 2021-07-02T03:30:00+01:00
0.085 | 2021-07-02T03:30:00+01:00 | 2021-07-02T04:00:00+01:00
0.118 | 2021-07-02T04:00:00+01:00 | 2021-07-02T04:30:00+01:00
0.083 | 2021-07-02T04:30:00+01:00 | 2021-07-02T05:00:00+01:00
0.107 | 2021-07-02T05:00:00+01:00 | 2021-07-02T05:30:00+01:00
0.105 | 2021-07-02T05:30:00+01:00 | 2021-07-02T06:00:00+01:00
0.102 | 2021-07-02T06:00:00+01:00 | 2021-07-02T06:30:00+01:00
0.103 | 2021-07-02T06:30:00+01:00 | 2021-07-02T07:00:00+01:00
0.095 | 2021-07-02T07:00:00+01:00 | 2021-07-02T07:30:00+01:00
0.24 | 2021-07-02T07:30:00+01:00 | 2021-07-02T08:00:00+01:00
0.139 | 2021-07-02T08:00:00+01:00 | 2021-07-02T08:30:00+01:00
0.219 | 2021-07-02T08:30:00+01:00 | 2021-07-02T09:00:00+01:00
0.144 | 2021-07-02T09:00:00+01:00 | 2021-07-02T09:30:00+01:00
0.197 | 2021-07-02T09:30:00+01:00 | 2021-07-02T10:00:00+01:00
0.377 | 2021-07-02T10:00:00+01:00 | 2021-07-02T10:30:00+01:00
0.357 | 2021-07-02T10:30:00+01:00 | 2021-07-02T11:00:00+01:00
0.27 | 2021-07-02T11:00:00+01:00 | 2021-07-02T11:30:00+01:00
0.56 | 2021-07-02T11:30:00+01:00 | 2021-07-02T12:00:00+01:00
0.923 | 2021-07-02T12:00:00+01:00 | 2021-07-02T12:30:00+01:00
0.674 | 2021-07-02T12:30:00+01:00 | 2021-07-02T13:00:00+01:00
0.133 | 2021-07-02T13:00:00+01:00 | 2021-07-02T13:30:00+01:00
0.327 | 2021-07-02T13:30:00+01:00 | 2021-07-02T14:00:00+01:00
0.377 | 2021-07-02T14:00:00+01:00 | 2021-07-02T14:30:00+01:00
0.395 | 2021-07-02T14:30:00+01:00 | 2021-07-02T15:00:00+01:00
0.302 | 2021-07-02T15:00:00+01:00 | 2021-07-02T15:30:00+01:00
0.64 | 2021-07-02T15:30:00+01:00 | 2021-07-02T16:00:00+01:00
0.51 | 2021-07-02T16:00:00+01:00 | 2021-07-02T16:30:00+01:00
0.167 | 2021-07-02T16:30:00+01:00 | 2021-07-02T17:00:00+01:00
0.383 | 2021-07-02T17:00:00+01:00 | 2021-07-02T17:30:00+01:00
0.229 | 2021-07-02T17:30:00+01:00 | 2021-07-02T18:00:00+01:00
0.112 | 2021-07-02T18:00:00+01:00 | 2021-07-02T18:30:00+01:00
0.107 | 2021-07-02T18:30:00+01:00 | 2021-07-02T19:00:00+01:00
0.131 | 2021-07-02T19:00:00+01:00 | 2021-07-02T19:30:00+01:00
0.101 | 2021-07-02T19:30:00+01:00 | 2021-07-02T20:00:00+01:00
0.142 | 2021-07-02T20:00:00+01:00 | 2021-07-02T20:30:00+01:00
0.107 | 2021-07-02T20:30:00+01:00 | 2021-07-02T21:00:00+01:00
0.117 | 2021-07-02T21:00:00+01:00 | 2021-07-02T21:30:00+01:00
0.112 | 2021-07-02T21:30:00+01:00 | 2021-07-02T22:00:00+01:00
0.13 | 2021-07-02T22:00:00+01:00 | 2021-07-02T22:30:00+01:00
0.155 | 2021-07-02T22:30:00+01:00 | 2021-07-02T23:00:00+01:00
0.167 | 2021-07-02T23:00:00+01:00 | 2021-07-02T23:30:00+01:00
0.143 | 2021-07-02T23:30:00+01:00 | 2021-07-03T00:00:00+01:00
0.177 | 2021-08-27T20:30:00+01:00 | 2021-08-27T21:00:00+01:00
0.212 | 2021-08-27T21:00:00+01:00 | 2021-08-27T21:30:00+01:00
0.187 | 2021-08-27T21:30:00+01:00 | 2021-08-27T22:00:00+01:00
0.181 | 2021-08-27T22:00:00+01:00 | 2021-08-27T22:30:00+01:00
0.183 | 2021-08-27T22:30:00+01:00 | 2021-08-27T23:00:00+01:00
0.153 | 2021-08-27T23:00:00+01:00 | 2021-08-27T23:30:00+01:00
0.187 | 2021-08-27T23:30:00+01:00 | 2021-08-28T00:00:00+01:00
0.15 | 2021-08-28T00:00:00+01:00 | 2021-08-28T00:30:00+01:00