Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 22nd 09, 10:14 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 1
Default convert decimal inches into feet and inches

I am using the following formula to convert decimal inches into feet and
inches. The problem I have is that the formula is not reducing the fractions.
For instance, when the figure is 35.625 it converts it to 2'-11 10/16"
instead of 2'-11 5/8". I need to keep the inches in 16th's but want the
formula to reduce the fraction when needed. Any suggestions on how to make
this happen?

=INT(F5/12)&"'-"&TEXT(MOD(F5,12),"# ??/16")&""""

  #2   Report Post  
Old April 22nd 09, 11:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default convert decimal inches into feet and inches

I'd start at David McRitchie's site
http://mvps.org/dmcritchie/excel/fractex1.htm

From work done by Bernie Deitrick.

Jason Stripling wrote:

I am using the following formula to convert decimal inches into feet and
inches. The problem I have is that the formula is not reducing the fractions.
For instance, when the figure is 35.625 it converts it to 2'-11 10/16"
instead of 2'-11 5/8". I need to keep the inches in 16th's but want the
formula to reduce the fraction when needed. Any suggestions on how to make
this happen?

=INT(F5/12)&"'-"&TEXT(MOD(F5,12),"# ??/16")&""""


--

Dave Peterson
  #3   Report Post  
Old April 23rd 09, 02:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 1
Default convert decimal inches into feet and inches

I actual dug a little deeper yesterday and found out how to do it. The
formula is shown below.
=INT(F5/12)&"'-"&TEXT(MOD(F5,12),"# ??/??")&""""
The only issue I have with this one is that it has extra spaces in the final
numbers when you don't have four numbers for the fraction. For instance,
2'-11 5/8" is actually 2'-11 5/8 ". It replaces the missing ?, from the
formula, with a space. This is close enough for me. If anyone knows how to
fix it though, let me know.

"Dave Peterson" wrote:

I'd start at David McRitchie's site
http://mvps.org/dmcritchie/excel/fractex1.htm

From work done by Bernie Deitrick.

Jason Stripling wrote:

I am using the following formula to convert decimal inches into feet and
inches. The problem I have is that the formula is not reducing the fractions.
For instance, when the figure is 35.625 it converts it to 2'-11 10/16"
instead of 2'-11 5/8". I need to keep the inches in 16th's but want the
formula to reduce the fraction when needed. Any suggestions on how to make
this happen?

=INT(F5/12)&"'-"&TEXT(MOD(F5,12),"# ??/16")&""""


--

Dave Peterson



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert inches & display as Feet Inches and Fractions -- BUG FREE Mark Main Excel Worksheet Functions 12 November 26th 08 08:50 PM
How do I convert decimal to feet and inches Erik Excel Worksheet Functions 5 October 25th 07 11:54 PM
Converting from feet, inches and fractions to inches and decimal p Dee Setting up and Configuration of Excel 5 September 18th 07 04:18 PM
Convert feet/inches to decimal dingy101 Excel Worksheet Functions 16 February 21st 06 10:18 PM
How do i convert feet and inches to a decimal value? go_chrisg Excel Worksheet Functions 4 May 22nd 05 04:33 PM


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

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017