I also thought the battle agains the Borg cube took at least a day.
King Daniel Into Darkness wrote:
But Picard orders red alert before they warp. It seems a bit of a stretch to do that days or weeks in advance of the battle
Red alert means for the crew to stay alert. That means a difference in shifts, more training, work on the tactical systems, blablabla. Explained!