It depends on the cause of the cloudiness.
If it's due to iron bacteria, you should have clear water within three days after starting treatment.
If the cause is sediment, you'll need to run your water for several hours or, in some cases, overnight to remove the cloudiness.