| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert column with inches to 2 columns "feet" and "inches"
I have a spreadsheet that has a column with total inches, but what I really
need is 2 columns that shows how many total feet there are in one column and how many left over inches there are in the 2nd column. What formula can I use? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert column with inches to 2 columns "feet" and "inches"
For feet: =int(a1/12)
For inches: =mod(a1,12) Regards, Fred "fsudiane" wrote in message ... I have a spreadsheet that has a column with total inches, but what I really need is 2 columns that shows how many total feet there are in one column and how many left over inches there are in the 2nd column. What formula can I use? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert column with inches to 2 columns "feet" and "inches"
Feet Column: =rounddown(a2/12,0)
Inches Column: =mod(a2,12) "fsudiane" wrote: I have a spreadsheet that has a column with total inches, but what I really need is 2 columns that shows how many total feet there are in one column and how many left over inches there are in the 2nd column. What formula can I use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How to format feet/inches (ft'in") | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| How do I set a cell format for Feet and Inches? i.e. 3'-10 1/2" | Excel Discussion (Misc queries) | |||
Linear Mode
