Spreadsheet: 525365d1498680632-help-cleaning-up-an-awkward-nested-formula-to-improve-calculation-speed-appointment-consolidation-file
Sheet: Sandbox

 | Date Rec'd | Date of Request | Time | Length | Location | GAP TIME TO NEXT | COMBINED TIME
 | 2017-07-03 00:00:00 | 2017-07-05 00:00:00 | 07:15:00 | 0.25 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-05 00:00:00 | 07:15:00 | 0.25 | East Side
 | 2017-07-03 00:00:00 | 2017-07-05 00:00:00 | 07:30:00 | 0.5 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-05 00:00:00 | 08:45:00 | 2 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-05 00:00:00 | 08:45:00 | 0.5 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-05 00:00:00 | 09:30:00 | 0.25 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-05 00:00:00 | 09:45:00 | 0.25 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-06 00:00:00 | 07:30:00 | 0.25 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-06 00:00:00 | 07:30:00 | 0.25 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-06 00:00:00 | 07:45:00 | 0.25 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-06 00:00:00 | 07:45:00 | 0.25 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-06 00:00:00 | 07:45:00 | 0.25 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-06 00:00:00 | 08:15:00 | 0.25 | East Side
 | 2017-07-03 00:00:00 | 2017-07-06 00:00:00 | 08:30:00 | 0.5 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-06 00:00:00 | 09:00:00 | 0.25 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-06 00:00:00 | 09:15:00 | 0.5 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-06 00:00:00 | 09:15:00 | 0.5 | East Side
 | 2017-07-03 00:00:00 | 2017-07-06 00:00:00 | 09:15:00 | 0.5 | East Side
 | 2017-07-04 00:00:00 | 2017-07-06 00:00:00 | 09:15:00 | 0.5 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-06 00:00:00 | 09:15:00 | 0.25 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-06 00:00:00 | 09:15:00 | 0.5 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-06 00:00:00 | 09:30:00 | 1 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-06 00:00:00 | 09:45:00 | 2 | East Side
 | 2017-07-04 00:00:00 | 2017-07-06 00:00:00 | 09:45:00 | 0.5 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-06 00:00:00 | 09:45:00 | 0.25 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-07 00:00:00 | 07:30:00 | 0.25 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-07 00:00:00 | 07:30:00 | 0.25 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-07 00:00:00 | 07:30:00 | 0.25 | East Side
 | 2017-07-05 00:00:00 | 2017-07-07 00:00:00 | 07:45:00 | 0.25 | East Side
 | 2017-07-05 00:00:00 | 2017-07-07 00:00:00 | 07:45:00 | 2 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-07 00:00:00 | 07:45:00 | 0.25 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-07 00:00:00 | 07:45:00 | 0.25 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-07 00:00:00 | 08:00:00 | 1 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-07 00:00:00 | 08:00:00 | 0.25 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-07 00:00:00 | 08:00:00 | 0.25 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-07 00:00:00 | 08:15:00 | 0.25 | East Side
 | 2017-07-04 00:00:00 | 2017-07-07 00:00:00 | 08:30:00 | 0.25 | East Side
 | 2017-07-05 00:00:00 | 2017-07-07 00:00:00 | 09:00:00 | 0.25 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-07 00:00:00 | 09:00:00 | 0.5 | Downtown
 | 2017-07-03 00:00:00 | 2017-07-07 00:00:00 | 09:00:00 | 0.5 | East Side
 | 2017-07-04 00:00:00 | 2017-07-07 00:00:00 | 09:00:00 | 0.25 | East Side
 | 2017-07-03 00:00:00 | 2017-07-07 00:00:00 | 09:15:00 | 1 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-07 00:00:00 | 09:15:00 | 0.25 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-07 00:00:00 | 09:15:00 | 0.25 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-07 00:00:00 | 09:30:00 | 0.25 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-08 00:00:00 | 07:15:00 | 1 | East Side
 | 2017-07-04 00:00:00 | 2017-07-08 00:00:00 | 07:15:00 | 0.25 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-08 00:00:00 | 07:30:00 | 0.25 | East Side
 | 2017-07-04 00:00:00 | 2017-07-08 00:00:00 | 07:30:00 | 0.25 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-08 00:00:00 | 07:30:00 | 1 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-08 00:00:00 | 07:45:00 | 0.25 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-08 00:00:00 | 08:00:00 | 1 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-08 00:00:00 | 08:00:00 | 1 | Downtown
 | 2017-07-04 00:00:00 | 2017-07-08 00:00:00 | 08:30:00 | 0.25 | East Side
 | 2017-07-05 00:00:00 | 2017-07-08 00:00:00 | 09:00:00 | 0.25 | East Side
 | 2017-07-06 00:00:00 | 2017-07-08 00:00:00 | 09:00:00 | 0.25 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-08 00:00:00 | 09:30:00 | 0.25 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-08 00:00:00 | 09:45:00 | 0.25 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-08 00:00:00 | 09:45:00 | 0.25 | East Side
 | 2017-07-07 00:00:00 | 2017-07-09 00:00:00 | 07:15:00 | 0.5 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-09 00:00:00 | 07:45:00 | 0.5 | Downtown
 | 2017-07-07 00:00:00 | 2017-07-09 00:00:00 | 08:00:00 | 0.25 | East Side
 | 2017-07-07 00:00:00 | 2017-07-09 00:00:00 | 08:00:00 | 0.25 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-09 00:00:00 | 08:00:00 | 0.5 | East Side
 | 2017-07-07 00:00:00 | 2017-07-09 00:00:00 | 08:00:00 | 2 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-09 00:00:00 | 08:15:00 | 2 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-09 00:00:00 | 08:30:00 | 0.5 | East Side
 | 2017-07-07 00:00:00 | 2017-07-09 00:00:00 | 08:30:00 | 0.5 | East Side
 | 2017-07-06 00:00:00 | 2017-07-09 00:00:00 | 08:30:00 | 0.25 | Downtown
 | 2017-07-07 00:00:00 | 2017-07-09 00:00:00 | 08:45:00 | 1 | Downtown
 | 2017-07-07 00:00:00 | 2017-07-09 00:00:00 | 08:45:00 | 0.5 | East Side
 | 2017-07-05 00:00:00 | 2017-07-09 00:00:00 | 08:45:00 | 0.5 | Downtown
 | 2017-07-07 00:00:00 | 2017-07-09 00:00:00 | 09:15:00 | 0.25 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-09 00:00:00 | 09:30:00 | 0.25 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-09 00:00:00 | 09:45:00 | 1 | East Side
 | 2017-07-05 00:00:00 | 2017-07-09 00:00:00 | 09:45:00 | 0.5 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-09 00:00:00 | 09:45:00 | 0.25 | East Side
 | 2017-07-05 00:00:00 | 2017-07-09 00:00:00 | 09:45:00 | 1 | Downtown
 | 2017-07-05 00:00:00 | 2017-07-09 00:00:00 | 10:00:00 | 1 | Downtown
 | 2017-07-07 00:00:00 | 2017-07-10 00:00:00 | 07:00:00 | 0.5 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-10 00:00:00 | 07:15:00 | 0.5 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-10 00:00:00 | 07:15:00 | 0.25 | East Side
 | 2017-07-06 00:00:00 | 2017-07-10 00:00:00 | 07:45:00 | 0.25 | East Side
 | 2017-07-06 00:00:00 | 2017-07-10 00:00:00 | 08:15:00 | 0.25 | Downtown
 | 2017-07-07 00:00:00 | 2017-07-10 00:00:00 | 08:30:00 | 0.25 | East Side
 | 2017-07-06 00:00:00 | 2017-07-10 00:00:00 | 09:15:00 | 0.25 | East Side
 | 2017-07-06 00:00:00 | 2017-07-10 00:00:00 | 09:15:00 | 0.25 | East Side
 | 2017-07-06 00:00:00 | 2017-07-10 00:00:00 | 09:30:00 | 0.25 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-10 00:00:00 | 09:30:00 | 1 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-10 00:00:00 | 09:30:00 | 0.25 | Downtown
 | 2017-07-06 00:00:00 | 2017-07-10 00:00:00 | 09:45:00 | 0.5 | Downtown
 | 2017-07-07 00:00:00 | 2017-07-10 00:00:00 | 09:45:00 | 1 | Downtown
 | 2017-07-07 00:00:00 | 2017-07-11 00:00:00 | 07:00:00 | 0.25 | East Side
 | 2017-07-07 00:00:00 | 2017-07-11 00:00:00 | 07:15:00 | 0.25 | East Side
 | 2017-07-07 00:00:00 | 2017-07-11 00:00:00 | 08:00:00 | 0.5 | Downtown
 | 2017-07-07 00:00:00 | 2017-07-11 00:00:00 | 09:15:00 | 0.5 | Downtown
 | 2017-07-07 00:00:00 | 2017-07-11 00:00:00 | 09:15:00 | 0.25 | East Side
 | 2017-07-07 00:00:00 | 2017-07-11 00:00:00 | 09:45:00 | 1 | Downtown
 | 2017-07-07 00:00:00 | 2017-07-11 00:00:00 | 09:45:00 | 1 | East Side