Google Maps Driving Times

good spot TMS though you could just embed a further Replace

getGoogDistanceTime = Evaluate("""" & Replace(Replace(Replace(getGoogDistanceTime, " hours ", " hour "), " hour ", ":"), " mins", "") & ":0.0" & """+0")

I have saved my version accordingly.

edit: should note it would still fail for minute distances but I would live with that as it would flag oversights.