Converting inches to feet & inches.
How do I create a formula to convert inches to show feet and inches
(examples, 118.75 = 9' 10 3/4" , 85.875 = 7' 1 7/8")? |
Check out this page of Chip Pearson's site:
http://www.cpearson.com/excel/fractional.htm tj "svech61" wrote: How do I create a formula to convert inches to show feet and inches (examples, 118.75 = 9' 10 3/4" , 85.875 = 7' 1 7/8")? |
Hi!
There may be something more elegant but this works: =ROUNDDOWN(INT(A1)/12,0)&"'"&" "&MOD(INT(A1),12)&TEXT(A1- INT(A1),"# ??/??")&"""" Biff -----Original Message----- How do I create a formula to convert inches to show feet and inches (examples, 118.75 = 9' 10 3/4" , 85.875 = 7' 1 7/8")? . |
All times are GMT +1. The time now is 04:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com