Magnetic excitations in two-leg spin 1/2 ladders: experiment and theory