The London 2012 Olympics have ended with a spectacular musical closing ceremony and the official handover to the next host city, Rio de Janeiro.The three-hour show featured some of the biggest names of British pop from decades past, including the Spice Girls, George Michael and Elbow.Games chief Lord Coe said: "When our time came - Britain, we did it right."The official Games flag was handed to the mayor of Rio before the flame at the Olympic Stadium was extinguished.President of the International Olympic Committee, Jacques Rogge, who declared the Games of the 30th Olympiad closed just before midnight, said: "We will never forget the smiles, the kindness and the support of the wonderful volunteers, the much-needed heroes of these Games."You, the spectators and the public, provided the soundtrack for these Games."Your enthusiastic cheers energised its competitors and brought a festive spirit to every Olympic venue."Best of BritishAt the close of the ceremony, watched in the stadium by the 10,000 athletes and 80,000 spectators, the flame was extinguished in dramatic fashion. Each nation will receive one of the cauldron's 204 petals.As fireworks went off above the east London stadium, the Who performed My Generation and the venue became a sea of red, white and blue confetti.The finale, which began with Big Ben chiming, paid tribute to UK music, fashion and culture.Prince Harry represented the Queen at the ceremony, which took place on top of a stage in the shape of a union jack and saw a volunteer cast of 3,500.The show saw the Spice Girls re-form to sing Spice Up Your Life from the top of five London taxis, and a surprise performance from Take That, who sang their hit Rule the World. It had been thought they would not appear because Gary Barlow was mourning the loss of his daughter who was delivered stillborn last Saturday.Artistic Director Kim Gavin also brought together household names, including George Michael, Jessie J, Emeli Sande, Madness, the Pet Shop Boys, One Direction, Ray Davies and Liam Gallagher, as the best of British music went on show to the world.During the ceremonial part of the show, the Olympic flag was waved aloft by London Mayor Boris Johnson and passed by Mr Rogge into the hands of the Mayor of Rio, Eduardo Paes.The Brazilian national anthem rang out and the stadium was transformed into the green and yellow colours of Brazil's flag.