The Met Office has revealed when the wet weather is set to end and 'hot conditions' are set to arrive