Hello,
A string is generated from google distance matrix API which is containing time. i.e. "1 hour 25 min"? How can we convert it to minutes i.e. 85?
Thank you
Hello,
A string is generated from google distance matrix API which is containing time. i.e. "1 hour 25 min"? How can we convert it to minutes i.e. 85?
Thank you
Hello and welcome to the forum.
Try this:
=LEFT(A1,FIND(" ",A1)-1)*60+TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",100)),200,100))
this should work too:
=LEFT(A1,FIND(" ",A1)-1)*60+LEFT(RIGHT(A1,6),2)
Last edited by 63falcondude; 03-27-2019 at 12:04 PM.
Or
Formula:Please Login or Register to view this content.
v A B 1 1 hour 25 min 85
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you.. This is working.
Glad we could help. Thanks for the rep!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks