Time‐dependent Hartree wave packet dynamical techniques for computation of electronically excited state optical spectra of many‐body quantum systems