adding REPLACE to this formula

[mole999]

I have this
=IFERROR(SUM(--LEFT(AP32,(FIND("h",AP32,1)-1))*60)+VALUE(MID(AP32,SEARCH("h",AP32)+1,SEARCH("m",AP32)-SEARCH("h",AP32)-1)),"")
which turns 9h0m into countable minutes

bright sparks at work have then adopted 8hr37m as a new way of writing
without mucking up the original functionality, where do i add REPLACE "r" with no space within the formula to accommodate the two variants so hr moves to h and then works as intended

 

[FormR]

Hi, here is an alternative that should handle both variations.

=IFERROR(1440*SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(AP32,"m",""),"hr",":"),"h",":"),"")

 

[mole999]

so much simpler, thank you