I am not sure how you are saying it happened in the movie. I am assuming you are not saying they just bashed it with it, but used it as a rocket?
But in one of the MythBusters episode they took a 60L cylinder, and sheared off the tip and it traveled like something like 20 to 30 feet, went through a cinder block wall, traveled another ~10 feet and went partially through another cider block wall.