How add fraction values in Excel

Question

Hello Team,

could you help me solve this issue...

Actually i want how to add fractions excel.If any formula is there?One example i mentioned below

212'-12"1/16+182'-8"3/16=? and 12"1/16+1"1/8.......

Thanks

Sanil

Answer 1

Hi Sani

I'm so sorry you are facing issues! I'm Maggie, an Independent Advisor from thr user community. I love helping other users in the Community by sharing my experience with Microsoft products.

You should mark them as fractions and then sum them as you would sum a "normal" number.

Please see image attached with example.

Please see here how to mark them as fractions:

https://support.office.com/en-us/article/displa...

Hope this helps!

I wish you a great day/night :)!

Maggie

Answer 2

Hi,

Maggie,

Thanks for giving wonderful example,i try your solution that one working perfectly. Actually i am a civil engineer i need to prepare bill of material in order that i need this formula.For your reference i am attaching excel snap.Kindly review and give good solution for me

Thanks and regards

Sanil

Answer 3

Imperial math is not 'natural' for Excel

Multiplying 24ft 9inches with 6ft 3inches using Excel imperial math-http://chandoo.org/wp/2014/04/14/feet-inches-arithmetic-in-excel/*****Imagine you are a carpenter and you are tasked with laying wooden floor*in the guest bedroom first. Here are the dimensions of that guest bedroom.

Width: 6ft 3inches   Length: 24ft 9inches

Size of individual wooden floor board: 2ft x 4inches

So the real question you have is, How many wooden floor boards should you buy?

.

**Working In Feet and Inches** ****http://excelribbon.tips.net/T010612\_Working\_in\_Feet\_and\_Inches.html

Your chosen occupation may require that you work with linear distances in feet and inches. Excel can do this, to a degree, but you need to understand what the limitations are.

.

.ET MR Macros.docx**Working with Imperial Linear Distances**

https://excelribbon.tips.net/T009752_Working_with_Imperial_Linear_Distances.html

Excel works with decimal values very easily. It is more difficult for the program to work with non-decimal values, such as those used for linear distances (miles, feet, etc.). Here’s a way you can approach the task of working with such values.

ET MR Macros.docx .

Conversion of Feet and Inches to Decimal Valueshttp://lacher.com/examples/lacher18.htm

Two Visual Basic for Applications User Defined Functions, one to convert from decimal inches to feet, inches and fractions. The second function converts from feet and inches to decimal inches. ET MR Macros.docx

Answer 4

Here is something I did not know, you can work with fractions in Excel

**Working With Fractions**

https://web.archive.org/web/20180107233318/http://spreadsheetpage.com/index.php/tip/working_with_fractions/

Some types of data, such as stock market quotes, normally display as fractions, not decimals. To enter a fraction in Excel, type the whole number (or integer) followed by a space, and then type the fraction, using a slash (for example, 5/8). If you type only a fraction, Excel may interpret it as a date (so it might read 5/8 as May 8). To avoid this mistranslation, enter 0, a space, and then the fraction.