The calculated distance (air line) between Hofheim in Unterfranken and Cologne is approximately 166 miles respectively 268 kilometers.
By car or train, the actual journey to Cologne is certainly longer, as only the direct route (as the crow flies) between Hofheim in Unterfranken and Cologne has been calculated here.
Air line (approximately)
268 kilometers
144 nautical miles