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