TV presenter Paddy McGuinness has said he was pushed to his “absolute limits” by Sir Chris Hoy while preparing for his BBC Children In Need ultra-endurance cycle challenge.