With Webservice I get from Google maps XML response and can calculate car travel time between 2 locations
Using this formula to get travel time
=FILTERXML(C14;"//duration[1]/text")
The output is formatted like xx hour(s) xx mins
I would like the format of the travel time converted in [h]:mm format
Using this formula to get travel time
=FILTERXML(C14;"//duration[1]/text")
The output is formatted like xx hour(s) xx mins
I would like the format of the travel time converted in [h]:mm format