Excel User Input Checkboxes to Calculate Travel Hours Across Various Time Zones

Hello Excel gurus!

I have wasted quite a bit of time trying to figure this out. I'm hopeful that Reddit can save me. :)

My department inherited a spreadsheet that calculates how many hours of time we spend traveling. The original spreadsheet was married to the format of a PDF flight itinerary that our travel people used. The travel people changed the spreadsheet (somehow - I don't know how/what - it looks the same to me) so now the old spreadsheet returns nearly all value! errors. The goal is to copy/paste the PDF into A2 and the rest of the sheet does the *magic*. Ultimately, said magic dumps into another tab.

Here's the before/after of the original spreadsheet:

Before Clicking Checkbox

After Clicking Checkbox - Middle column

I dumped the old spreadsheet into Google Sheets to unprotect it and aim to reverse engineer the *magic*. Most of the *magic* is back and jives with the new PDF format. (See below, colorful spreadsheet.)

The only thing (I think - TBD this thread, I guess) I can't seem to figure out is why the checkboxes in row 3 don't work (below, what appears in the snips to be my second row with boxes all checked). Checkboxes in rows 2 and 4 work. I've tried dragging the cells from 2 into 3, from 4 into 3, and I've tried going from column G into F (I've tried every iteration of copy/paste that I know and I've tried every iteration of copy/paste that right clicking offers). Design Mode is off for all of the checkboxes. When I right click the checkbox, the Format Control cell link is linked to the cell of the checkbox (as applicable for each column).

New Spreadsheet Example - All checkboxes checked in row with the issues.

New Spreadsheet Example - All boxes unchecked (no changes that I can tell)

The largest sheet I have made in the past was seven columns.

Any help that can be provided, is much appreciated!