The calculated distance (air line) between Lehrte and Cologne is approximately 164 miles respectively 263 kilometers.
By car or train, the actual journey to Cologne is certainly longer, as only the direct route (as the crow flies) between Lehrte and Cologne has been calculated here.