Calculate alphanumeric string to an integer in Excel -

Calculate alphanumeric string to an integer in Excel -

i have issue i've not been able figure out many of ideas presented in other posts. info comes in excel , here examples of each manner given cell might have data:

4days 4hrs 41mins 29seconds 23hrs 43mins 4seconds 2hrs 2mins 52mins 16seconds

the end result calculate total minutes while allowing seconds ignored, previous values end follows:

6041 52 1423 122

would have thought how go that?

thanks assistance!

bit tedious (and assumes units plural - produces results in different order example) but, formulae only, if info in column a, in b1 , copied down:

="="&substitute(substitute(substitute(substitute(substitute(a1,"days","*1440+"),"hrs","*60+"),"mins","*1+"),"seconds","*0")," ","")&0

then re-create b , paste special values c , apply text columns c tab delimiter.

string excel excel-vba time excel-formula