MS EXCEL Convert Height Decimal Feet Inches to Inches Only

0 votes
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 by Edureka
• 13,690 points
561 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Others

0 votes
1 answer

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

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

answered Oct 15, 2022 in Others by narikkadan
• 63,600 points
876 views
0 votes
0 answers

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

Nov 2, 2022 in Others by Kithuzzz
• 38,000 points
597 views
0 votes
1 answer

Excel formula to convert number to both feet and inches

If you want the answer to be ...READ MORE

answered Jan 5, 2023 in Others by narikkadan
• 63,600 points
786 views
0 votes
1 answer

Converting Feet-Inches to Inches Excel

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

answered Oct 15, 2022 in Others by narikkadan
• 63,600 points
1,553 views
0 votes
1 answer

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

answered Oct 15, 2022 in Others by narikkadan
• 63,600 points
1,394 views
0 votes
1 answer

Convert Feet to meters in excel with macro for entire column

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

answered Oct 27, 2022 in Others by narikkadan
• 63,600 points
757 views
+4 votes
3 answers

Will Power BI take over MS Excel

Well, if your taking about just data ...READ MORE

answered Sep 26, 2018 in Power BI by Vardhan
• 13,150 points
1,348 views
0 votes
1 answer

Why should I shift from MS Excel to Power BI

There are a lot of advantages from ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 52,350 points
746 views
+1 vote
1 answer

How is power BI different from excel

Power series plug-ins you can do certain ...READ MORE

answered Sep 26, 2018 in Power BI by Hannah
• 18,520 points
758 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP