Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please advise on length addition!
Can someone advise on how to add length in Excel, for example, I need to add
5 ft 8 in and 7 ft 9 in. I want an answer to be also in feet and inches. Gladly appreciate! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please advise on length addition!
Hi
Have a read of Chip's site: http://www.cpearson.com/excel/FeetInches.htm It gets a bit complex but it should set you off in the right direction! Hope this helps. Andy. "student" wrote in message ... Can someone advise on how to add length in Excel, for example, I need to add 5 ft 8 in and 7 ft 9 in. I want an answer to be also in feet and inches. Gladly appreciate! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please advise on length addition!
See the DOLLARDE and DOLLARFR functions in help.
=DOLLARFR(DOLLARDE(5.08,12)+DOLLARDE(7.09,12),12) returns 13.05. These functions are part of the Analysis ToolPak add-in, so you'll need to have that add-in loaded. Go to the Tools menu, choose Add-Ins, and check Analysis ToolPak in the list of available addins. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "student" wrote in message ... Can someone advise on how to add length in Excel, for example, I need to add 5 ft 8 in and 7 ft 9 in. I want an answer to be also in feet and inches. Gladly appreciate! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please advise on length addition!
In addition to Chips's excellent method, you could enter (in A1) 5 8/12 and
(in A2) 7 9/12 In A3 enter =A1+A2 To keep Excel from rationalizing fractions like 8/12 to 2/3, format the cell as # ??/12 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "student" wrote in message ... Can someone advise on how to add length in Excel, for example, I need to add 5 ft 8 in and 7 ft 9 in. I want an answer to be also in feet and inches. Gladly appreciate! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to calulate length of time | Excel Worksheet Functions | |||
Create fields in a form with a fixed length | Excel Discussion (Misc queries) | |||
Field length of VBA totals in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I export an Excel spreadsheet with fixed length rows? | Excel Discussion (Misc queries) | |||
Exporting from Excel to a Fixed Length Flat File | Excel Worksheet Functions |