If you have limited time in Spain and/or this is your first visit to Spain, I would recommend about three hours for a Cordoba day trip from Seville. This allows enough time to see the Mezquita, snap a few pictures of the Roman bridge, and wander around the surrounding old town a bit.