Met Office has issued a yellow weather warning, forecasting 8 hours of thunderstorms within just one hour, potentially leading to flooding and travel disruptions.