Assuming a temperature of 20 degrees celsius or less, and the water pipe is not in use, it will take approximately 4 to 5 hours for a water pipe to freeze and burst.