I didn't get that "Oh god, please be over now" feeling from X until I was doing sidequests to get weapons and stuff, right before attacking Sin so I basically could make it be over any time I felt like it. I got that feeling from VII about two or three hours after I left the city.