I created a Google Sheets template for planning "working roadtrips" that automatically calculates driving time and distance from the Google Maps Directions API. Have a copy!

https://tsmith.com/blog/2020/magic-travel-spreadsheet/