Olympic cyclist Sir Chris Hoy has revealed TV presenter and radio host Paddy McGuinness raised more than £8 million after finishing a 300-mile charity cycle ride for BBC Children In Need.