Using MS Excel (2010), I would like a formula (Not VBA/Macros) that will convert Decimal Feet, Inches and Fraction of a person's height to Only inches.

Example: John is 6' 1 1/4" tall, I have converted the Total height to decimals = 73.250, and would like to convert the Decimal output to only inches, including fraction of height = 73 1/4"
Feb 10, 2022 in Others 365 views

## Excel Formula to convert from cm to inches and feet & round off to two digits

Use the TEXT function to format, and ...READ MORE

## Converting feet & inches (e.g., "5 ft 1 in") to decimal feet using VBA or Excel

I have a database with a few ...READ MORE

## Converting Feet-Inches to Inches Excel

We must parse the data because these ...READ MORE

## Convert text to number in Google Sheets & Excel

Try: =INDEX(IF(REGEXMATCH(A1:A4&""; "M"); REGEXEXTRACT(A1:A4; "\d+.\d+|\d+")*1000000; IF(REGEXMATCH(A1:A4&""; "k"); ...READ MORE

## Convert Feet to meters in excel with macro for entire column

You can convert Feet to Kilometers using ...READ MORE

+1 vote