We theoretically study the magnetic excitations in a frustrated two-leg spin-ladder system, in which antiferromagnetic exchange interactions act on the nearest-neighbor and next-nearestneighbor bonds in the leg direction, and on the nearest-neighbor bonds in the rung direction. A dynamical spin correlation function at zero temperature is calculated using the dynamical densitymatrix renormalization-group method for possible magnetic phases, i.e., columnar-dimer and rungsinglet phases. The columnar-dimer phase is characterized by multi-spinon excitations with a spin gap, whereas the rung-singlet phase is dominated by the triplet excitation in the rung direction. One major difference found between these two phases appears in the spectral weight of magnetic excitations, in particular, the bonding and anti-bonding modes in the rung direction. Therefore, we can distinguish one phase from the other by the difference in the spectral weight. Furthermore, we examine the effect of frustration on both modes in the rung-singlet phase with a perturbation theory from the strong coupling limit. The anti-bonding mode is shown to be stable against frustration, and a wave number with minimum excitation energy is shifted from being commensurate to being incommensurate. In contrast, the bonding mode is merged into the continuum excitation of multiple triplet excitations by increasing frustration. By comparing our results with inelastic neutron scattering experiments for BiCu2PO6, the magnitude of the magnetic exchange interactions and the ground state will be determined.