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