PC Review


Reply
Thread Tools Rate Thread

Convert Cm to Feet and Inches

 
 
Nigel
Guest
Posts: n/a
 
      14th Sep 2008
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
 
Reply With Quote
 
 
 
 
Marshall Barton
Guest
Posts: n/a
 
      14th Sep 2008
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]
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:41 AM.