Converting d h m to hours

[Brambles74]

=SUM(MID(0&A2&"000",FIND({"d","h","m"},0&A2&"xxdhm")-2,2)*{1440,60,1})/60

This equation only works for up to 99 days - how do i change it to handle 100 plus days

109d 23h 5m to hours?

 

[Anthony47]

Maybe

=LET(myD,A2,DD,TEXTBEFORE(myD,"d",,1,0,0),HH,RIGHT(TEXTBEFORE(myD,"h",,1,0,"000"),2),MM,RIGHT(TEXTBEFORE(myD,"m",,1,0,"000"),2),DD*24+HH+MM/60)

 

[FormR]

Hi, welcome to the forum, here's another option you can try:

Book1
	A	B
1
2	1d	24
3	99d	2376
4	99d 1m	2376.02
5	1h 1d	25
6	5h 1m	5.01667
7	1d 1m 5h	29.0167
8	50m 3d	72.8333
9	1m	0.01667
Sheet1

Cell Formulas
Range	Formula
B2:B9	B2	=SUM(EXPAND(TEXTSPLIT(A2,{"d","h","m"},,1),,3,0)*SORTBY({1440,60,1}/60,FIND({"d","h","m"},A2&"dhm")))

 

[Brambles74]

Many thanks to both Anthony and FormR. Both formula work and learned myself. Kind regards