Convert feet & inches to decimal feet in Excel

The video offers a short tutorial on how to convert feet & inches to decimal feet in Excel.

[rcampbell]

Couldn't get it to work Prashant. Macro is:

Function Ftincesconvert(pInput As String) As Double
Ftinchesconvert = Split(pInput, " ft ")(0) + Split(Split(pInput, " ft ")(1), " in")(0) / 12
End Function

?

Maybe next time put the macro in the description?

[Sabareeswaran-fykn]

Function Ftinchesconvert(pInput As String) As Double
Ftinchesconvert = Split(pInput, "ft")(0) + Split(Split(pInput, "ft")(1), "in")(0) / 12
End Function
This module works...

[jgbains]

Can you please do a video for different format instead of ft and in we have " and '

[alexl]

How to make this work when inches include fractions? For example: 9ft 11-1/2in?

[lindamordosky]

Got it to work but it a very restrictive

[PriyaSharma-fcdn]

Feet, inch, feet, inch, or qty ko kease calculate karenge

[jerodmyers]

Doesn't work with things that just have feet