Remove "h" and "n" from time value

[BRISBANEBOB]

I am trying to convert a time value e.g. 508h 30.0n into a single decimal value i.e. 508.5. I can strip off the "h" but failing to combine it with the second part. I have attached a sample of what I am trying to achieve.

Grateful for any assistance.

[AliGW]

Don't understand, sorry.

What are you trying to do with this?

=580+(49.81/60)

The values in the workbook are all text.

[shukla.ankur281190]

May be try in

I10=(LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(I2,"h",""),"n","")," ",REPT(" ",99)),99)+0)+(RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(I2,"h",""),"n","")," ",REPT(" ",99)),99)+0)/60

[kvsrinivasamurthy]

In I9 then copied across

=0+LEFT(I2,FIND("h",I2)-1)+MID(SUBSTITUTE(I2,"n",""),FIND("h",I2)+1,250)/60

[menem]

Please try

=VALUE(LEFT(I2,FIND("h",I2)-1))+(VALUE(MID(LEFT(I2,LEN(I2)-1),FIND(" ",I2)+1,100))/60)


Regards.

[BRISBANEBOB]

Once again, thanks to all. Some thinking that always leaves me amazed.

[davsth]

do you get and 30h for they would error
perhaps the below may fix that
=IFERROR(LEFT(L2,SEARCH("h",L2,1)-1)+MID(L2,SEARCH("h",L2,1)+1,5)/60,LEFT(L2,SEARCH("h",L2,1)-1)*1)

[torachan]

No on sheet formula.
Double click on required cell for in-situ conversion.
torachan.