Convert Cm to Feet and Inches

's Computer Specifications

I have a field on a table called CM and 2 other fields called feet and inches

I can convert from Feet and inches to Cm but I need to be able to convert
from CM to feet and Inches and put the appropriate value in each field

Any advice is as always appreciated

Thanks

's Computer Specifications

Nigel wrote:

>I have a field on a table called CM and 2 other fields called feet and inches
>
>I can convert from Feet and inches to Cm but I need to be able to convert
>from CM to feet and Inches and put the appropriate value in each field

Total inches = .3937 times centimeters

Feet = integer part of total inches divided by 12

Inches = total inches minus 12 times feet

--
Marsh
MVP [MS Access]

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert decimal inches into feet and inches	Jason Stripling	Microsoft Excel Misc	2	23rd Apr 2009 02:45 PM
Convert inches & display as Feet Inches and Fractions -- BUG FREE	Mark Main	Microsoft Excel Worksheet Functions	9	26th Nov 2008 08:50 PM
convert inches to feet, inches	airutah	Microsoft Access Reports	2	27th Feb 2008 06:08 PM
is there a macro that will convert from inches to feet and inches	=?Utf-8?B?Y2FibGUgZ3V5?=	Microsoft Excel Misc	1	20th Jun 2005 07:29 PM
how to convert feet-inches-fractions to feet (or inches) in Excel	=?Utf-8?B?Sm9obiBCYXRlcw==?=	Microsoft Excel Worksheet Functions	1	23rd Sep 2004 08:24 PM