Calculating and adding time

The #NAME? error is almost certainly because SCAN, VSTACK, and the # spill reference only work in Microsoft 365's dynamic array engine — if you're on Excel 2019/2016 or another older version, those functions won't be recognized.

Quick checks:

Confirm which Excel version you're running (365 vs. one-time purchase).

If the startTime array formula itself fails, the startTime# reference will cascade errors downstream.

For adding/removing rows without breaking things, convert your source data into an Excel Table (Insert > Table) — combined with dynamic array formulas, it'll auto-resize as rows change.

I ran into similar formula compatibility issues in the last 2 months. While adjusting script outputs for an online fitness calculator. Standardizing the formula ranges fixed it.

Let me know your Excel version if you'd like a non-array alternative formula.