It depends on the severity of the problem and the products you use to fix it. For mild cloudiness, adding a clarifier can restore clarity within 24 hours.
However, it may take longer if your water is severely cloudy due to algae or other contaminants. In such cases, use shock treatment and flocculent. These may take up to three days to achieve results.