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