Spreadsheet: 738122d1624858567-calculate-running-totals-and-stop-if-total-exceeds-number-on-given-date-sample
Sheet: Sheet1

DATE | Time | Total | Running Total |  |  |  |  | calculate running totals and stop if total exceeds number on given date
2020-05-17 00:00:00 | 11:15:00 | -0.4000000000000004
2020-05-17 00:00:00 | 12:15:00 | 7.140000000000001 |  |  | <--- for this particular day, the first two totals (-0.4 + 7.14 are less than 10, so I want to have the word "continue" appear
2020-05-17 00:00:00 | 12:25:00 | 12.96 |  |  | <--- as cell E3 has the word continue, need to get the next running total (19.7). As this figure is >= 10, I want to just have the total appear and STOP CALCULATIONS FOR THAT PARTICULAR DAY
2020-05-17 00:00:00 | 13:00:00 | 0.5 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 13:25:00 | 18.18 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 13:30:00 | 2.799999999999999 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 13:35:00 | 13 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 13:40:00 | 15.34 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 13:45:00 | 4.399999999999999 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 13:50:00 | 3.600000000000001 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 14:00:00 | 4.559999999999999 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 14:05:00 | 6.800000000000001 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 14:10:00 | 7.200000000000003 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 14:15:00 | 10 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 14:22:00 | 1.1 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 14:35:00 | 11 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 14:40:00 | -18 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 14:45:00 | -22 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 14:50:00 | 0.2000000000000028 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 14:57:00 | 16.9 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 15:05:00 | 11.8 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 15:10:00 | 15.9 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-17 00:00:00 | 15:15:00 | -14 |  |  | <--- as the total above in cell [NAME] is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-18 00:00:00 | 12:55:00 | 22.4 |  |  | <--- new day starts here, and the first total is >= 10 so I want the total to appear here and STOP CALCULATIONS FOR THIS PARTICULAR DAY
2020-05-18 00:00:00 | 13:15:00 | -1.800000000000001 |  |  | <--- as the total above in cell E25 is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-18 00:00:00 | 13:50:00 | -16 |  |  | <--- as the total above in cell E25 is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-18 00:00:00 | 14:10:00 | -14 |  |  | <--- as the total above in cell E25 is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-18 00:00:00 | 14:25:00 | -22 |  |  | <--- as the total above in cell E25 is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-18 00:00:00 | 14:45:00 | 17.16 |  |  | <--- as the total above in cell E25 is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-18 00:00:00 | 15:04:00 | 13.4 |  |  | <--- as the total above in cell E25 is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-18 00:00:00 | 15:25:00 | 5.399999999999999 |  |  | <--- as the total above in cell E25 is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-18 00:00:00 | 15:40:00 | 10.56 |  |  | <--- as the total above in cell E25 is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-18 00:00:00 | 16:05:00 | 12.16 |  |  | <--- as the total above in cell E25 is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-18 00:00:00 | 16:15:00 | 5.100000000000001 |  |  | <--- as the total above in cell E25 is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-18 00:00:00 | 16:40:00 | -18 |  |  | <--- as the total above in cell E25 is >= 10, I want to stop any further calculations for this day, leave a blank cell and start again on the next day
2020-05-19 00:00:00 | 11:10:00 | -3.6 |  |  | <--- new day starts here, the first total (-3.6) is less than 10, so I want to have the word "continue" appear
2020-05-19 00:00:00 | 11:46:00 | -20 |  |  | <--- the next total (-3.6 + -23.6) is less than 10, so I want to have the word "continue" appear
2020-05-19 00:00:00 | 12:00:00 | -18 |  |  | <--- the next total is less than 10, so I want to have the word "continue" appear
2020-05-19 00:00:00 | 12:22:00 | 9.36 |  |  | <--- the next total is less than 10, so I want to have the word "continue" appear
2020-05-19 00:00:00 | 12:35:00 | 3.800000000000001 |  |  | <--- the next total is less than 10, so I want to have the word "continue" appear
2020-05-19 00:00:00 | 12:50:00 | -20 |  |  | <--- the next total is less than 10, so I want to have the word "continue" appear
2020-05-19 00:00:00 | 12:57:00 | -4.199999999999999 |  |  | <--- the next total is less than 10, so I want to have the word "continue" appear
2020-05-19 00:00:00 | 13:17:00 | -3.600000000000001 |  |  | <--- the next total is less than 10, so I want to have the word "continue" appear
2020-05-19 00:00:00 | 13:25:00 | -18 |  |  | <--- the next total is less than 10, so I want to have the word "continue" appear
2020-05-19 00:00:00 | 13:30:00 | -26 |  |  | <--- the next total is less than 10, so I want to have the word "continue" appear
2020-05-19 00:00:00 | 13:34:00 | 2.9 |  |  | <--- the total on this particular day ends on -97.34, so I want this total to appear in cell E47
2020-05-20 00:00:00 | 12:40:00 | -3.699999999999999 |  |  | <--- new day starts here, the first total (-3.7) is less than 10, so I want to have the word "continue" appear
2020-05-20 00:00:00 | 13:00:00 | 19.32 |  |  | <--- as cell E48 has the word continue, need to get the next running total (15.62). As this figure is >= 10, I want to just have the total appear and STOP CALCULATIONS FOR THAT PARTICULAR DAY