It takes approximately three weeks from the day your campaign ends for the funds reach your bank account. Making sure your Stripe account setup is complete will ensure this is done swiftly.
Funds can only be sent if the project owner has completed their Stripe account setup. If you login to Stripe, you can check your account status. If the setup is not complete then Stripe sends out regular reminder emails to do so.
If the Stripe setup is not complete, then the funds are held in perpetuity until it is. More information on setting up Stripe accounts can be found here.
N.B. If your project did not receive a pledge from a Spacehive partner (such as your local council), then funds may be paid out within less than two weeks.