For phone line broadband connections, it can take up to 14 days. Fibre broadband connections can be activated sooner. How long it will actually take depends on whether you need an engineer to come out or if anything needs activating.