Max value in cell - overflow into adjacent cell

The 'Target' in a Worksheet_Change event is the cell address of the cell you manually changed (or via code), not one that changes via formula/calculation. So in this case, the Target.Address would never be D2 as you're only changing cells starting in row 5 (or on other worksheets).

You would likely need to use the Worksheet_Calculate event, and adjust the code to check the value in 'Test User'!D2 upon each calculation attempt.

Nope, that didn't work. Trying to get creative here, but not seeing a path forward. I can get it to work on manually entered fields, just not on a calculated field, which you said, of course.

The crux of the project lies in being able check the completed time vs the goal time - and not factor extra time into the reporting numbers. I can continue to do it manually, but it gets a little tedious.