The calculated distance (air line) between Herzberg am Harz and Cologne is approximately 155 miles respectively 249 kilometers.
By car or train, the actual journey to Cologne is certainly longer, as only the direct route (as the crow flies) between Herzberg am Harz and Cologne has been calculated here.
Air line (approximately)
249 kilometers
134 nautical miles