Despite receiving a mauling from critics the movie which tells the tale of a workaholic who finds a magic remote control that allows him to fast-forward and rewind different parts of his life took $40 million and became Sandler's sixth No1 opening.
After two weeks at the top, Pixar's Cars slipped to No2 ($22.5 million) followed by Jack Black's Nacho Libre ($12.1 million). A new entry at four is thriller Waist Deep ($9.4 million) starring Tyrese Gibson, and rapper The Game.
The third installment of The Fast And The Furious franchise - Tokyo Drift completes the Top 5.