Hello,
this macro is using the openroutes service API to calculate directions on diverse means of transportations.
As entry data, you will need to have an ID per row, a departure and a destination. As a result, you will get the path between your departure and destination (for each row) and the time in seconds associated with this route. If you picked multiple means of transportations, you will retrieve multiple rows (one per transportation method).
This macro is using https://openrouteservice.org/ , to use the macro, you will need to create an account on the site. The free plan is limiting the API to 2000 calls per 24 hours and 40 per minutes (which has been configured in the API itself).
Feel free to try it
