Remember Me?

#1
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 1
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
 external usenet poster Posts: 2,389
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
 external usenet poster Posts: 2
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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM Minx Excel Discussion (Misc queries) 4 November 26th 07 09:54 PM inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM BCB New Users to Excel 7 May 13th 06 10:02 PM JB Excel Discussion (Misc queries) 1 March 1st 06 12:58 AM

All times are GMT +1. The time now is 01:39 AM.