I've been working on creating stationary gun turrets that can shoot down missiles in my game. The bullets are affected by gravity while the missile moves in a linear path at a constant rate as if it had no acceleration or gravity.

My math is most likely wrong because it doesnt work even after I've tweaked and changed a few things.

Could someone please explain the derivation of the correct formula?