Half a month’s worth of rain fell in just three hours causing widespread transport disruption in both Edinburgh and Kirkcaldy.