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