Free Microsoft Excel 2013 Quick Reference

formula to convert decimal feet to feet inch sixteenths

I would like to write a formula in excel, without using macros, to convert
decimal feet to feet-inch-sixteenths.

Can someone help me ?


Post your answer or comment

comments powered by Disqus
i am trying to write a formula in excel, without using VB/macros, that will
convert decimal feet to feet-inch-sixteenths. (ex. 4.5417 to 4-6-8)

can anyone help me with this

Can you provide a formula to convert a decimal to an inch & fraction?
I am using Excel 2000.
Thank you for your help.

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")&""""

I need a formula that takes a decimal feet value of 18.04461942 and converts it to a fractional feet value of 18' 0 9/16".

Also, there needs to be a way to reduce the fractions down to the smallest value.

Examples: 4/16" should not reduce to 2/8" but rather 1/4".
8/16" should not reduce to 4/16" or 2/4" but rather 1/2"

I will only need values down to 1/16" of an inch. No need to go lower.

Any ideas?

Can you provide a formula to convert a decimal to an inch & fraction?
I am using Excel 2000.
Thank you for your help.

Hello all,
I do a lot of work in astronomy and we use angles and time, sort of, interchangeably.
I have created custom formats which display degrees, minutes and seconds and hours, minutes, and seconds for any number string typed into a cell.
The symbols for angles line up, naturally, as superscripts.
Can I do that with time symbols.

For example 12° 34' 45" is easy.
How about 12h 34m 45s, but with the h,m, and s as superscripts?

I attached a pic, the custom formats I'd like to alter are in yellow.
Any help would be significantly appreciated.
Scott

P.S. My first thought was to create them as special characters in the SYMBOL dialogue box.

I see a lot of info on the web about this in Excel and a lot of formulae. Some quite extravagent.
I have used two formulas to convert between Degrees Minutes and Seconds and Decimal Degrees for a while.

From DMS (or Hours Minutes Seconds),
=(TRUNC(D6/10000)+TRUNC(0.01*MOD(D6,10000*SIGN(D6)))/60+MOD(D6,100*SIGN(D6))/3600)
The entry in cell D6 would be 89° 15' 32.77", for example, and the result 89.2591019849.

From Decimal Degrees (or Decimal Hours) to DMS (or HMS),
=10000*(TRUNC(D35))+100*(TRUNC(MOD(D35,SIGN(D35))*60))+(MOD(D35,SIGN(D35))-TRUNC(MOD(D35,SIGN(D35))*60)/60)*3600
The entry in cell D35 would be 2.5731869450 and the result 2h 34m 23.s473.

I also use a custom cell format to distinguish Degrees Minutes Seconds (and Hours Minutes Seconds).
The cell format is shown in the attached pic. When entering numbers, the decimal falls after the whole seconds.
So, 89° 15' 32.77", is entered as 891532.77.

Hi,
Dumb question. I pulled some data for latitude and longitude for some locations from mySQL database. I think they may be in some sort of ASCII or binary format Latitude (0.2123453) Longitude (0.3872453). Is there a formula to convert these to regular lat and long decimals in this format like 47.344 -12.342??

Hi

From a down load I am looking for a formula to convert from the download format
to the Required Result below

The download format is in a custom date format
[h]:mm:ss to #.##

Download Required result
1:19:00 1.19
1:31:00 1.31
1:59:00 1.59
2:18:00 2.18
12:00:00 12.00
16:00:00 16.00
149:00:00 149.00
420:00:00 420.00
824:00:00 824.00
954:52:00 954.52
1016:00:00 1,016.00

Does anyone know how to do this?

Kind Regards

Thomas

Hi all, I need to convert decimal numbers to hh:mm format in my workbook.
For instance 3/4 hour coms in decimal .75 which I need to convert into hh:mm
in next cell, since the rest of the spreadsheet is in that format.
Can anyone help please?
Paul

I would like to convert decimal values (-33.654873) to degrees/minutes/seconds
I am looking for an automatic function to do this.

-33.654873 = -33 degrees 39 minutes (0.654873*60 = 39.29238) 18 seconds
(0.29238 * 60 = 17.54)

Is there a way to do this autmatically?

Kind regards,

Florin Balcu
Perth, Western Australia

Is there any formula to convert the numerical in word form?

Such as i want to write

A B C D E
F
1 12 "Twelve"

What formula or format should be set in such a case?

Please help me.

Need formulae to convert decimal degree (lattitude/longitude) into Degree,
Minutes, Seconds format.

I have the following:
Lattitude data of 0.1741463938 and to convert to decimal degrees, I muliply
by 180 which gives me decimal degrees of 31.3463508840. Now I need to
convert to a Degree, Minute, Seconds format (N34* 50' 56.04"). Note: the '*'
represents the 'degree' symbol - did not know how to display the symbol.
Need to also display whether 'N' (North) or 'S' (South) based on actual
coordinate.

For Longitude, I have data of -0.4758427618 *180 = -85.6516971240 (decimal
degrees) and need to also convert to Degree, Minute, Seconds format (W16* 40'
23.54"). Note: the '*' represents the 'degree' symbol - did not know how to
display the symbol. Need to also display whether 'W' (West) or 'E' (East)
based on actual coordinate.

The formulae needed will take the original lat/long data, multiplied by 180,
and then ???? applied to deliver the data in Degrees, Minutes, Seconds format.

Thank you very much for your assistance.

Tim

I found the =BAHTTEXT() formula to convert to Thai, but can't find anything
to convert in English. For example, I am trying to convert "123" into "one
hundred and twenty three". Can anyone help me?

For instance:
first column
10k
10m
10b

I need a formula to convert them and put into the second column for
10,000
10,000,000
10,000,000,000

Is it possible?
Thanks.

Hi everybody,

Would like your help to advise on ow to set a formula on the following
Example : for 4/13/2006 11:22, how to set a formula to convert the US
mountain time to Asia/Singapore time?

US mountain time Convert to Asia/Singapore time
=========== ====================
4/13/2006 11:22 Please advise me the fourmula
4/13/2006 11:22
4/13/2006 11:22
4/13/2006 11:21
4/13/2006 11:20
4/13/2006 11:21
4/13/2006 11:20
4/13/2006 12:20
4/17/2006 3:10
4/18/2006 3:59
4/19/2006 2:32
4/18/2006 18:00
4/18/2006 2:59
4/18/2006 2:59
4/19/2006 2:34
4/19/2006 11:32

Your help is really much appreciated.

Thank you.

Hi

I am wondering if anyone have a formula to convert times ie:

1214 to 12:14:00

Would be really greatful if some could help as I really need this and Im completly goosed

I am trying to find an Excel formula to convert the first three (3) digits of a person’s social security number to the state in which a person first applied for a Social Security Card. For example, social security numbers which start from 449 to 467 represents a Texas, 486 to 500 present Missouri and so on. Based on the table on the Social Security Administration’s web site (http://www.ssa.gov/employer/stateweb.htm), I would like to be able to put social security number in Column A and obtain the state in column B. Thank you for your effort and time

Hi,

Can anyone help me getting formula to convert Pacific Standard Time (PST) into Indian Standard Time (IST). The result should show time in AM/PM

Thanks in advance.

how do I create a formula to convert kilograms to pounds

I AM TRYING TO FIND A WAY TO CONVERT DECIMAL NUMBERS TO WORDS I.E. 1024 TO
ONE THOUSAND AND TWENTY FOUR. IS THIS POSSIBLE???

Need formulae to convert decimal degree (lattitude/longitude) into Degree,
Minutes, Seconds format.

I have the following:
Lattitude data of 0.1741463938 and to convert to decimal degrees, I muliply
by 180 which gives me decimal degrees of 31.3463508840. Now I need to
convert to a Degree, Minute, Seconds format (N34* 50' 56.04"). Note: the '*'
represents the 'degree' symbol - did not know how to display the symbol.
Need to also display whether 'N' (North) or 'S' (South) based on actual
coordinate.

For Longitude, I have data of -0.4758427618 *180 = -85.6516971240 (decimal
degrees) and need to also convert to Degree, Minute, Seconds format (W16* 40'
23.54"). Note: the '*' represents the 'degree' symbol - did not know how to
display the symbol. Need to also display whether 'W' (West) or 'E' (East)
based on actual coordinate.

The formulae needed will take the original lat/long data, multiplied by 180,
and then ???? applied to deliver the data in Degrees, Minutes, Seconds format.

Thank you very much for your assistance.

Tim

Morning,

We have a program that exports a table from Auto-cad to Excel, using a
program called TableBuilder. It exports using feet, inches and fractions eg
6'-5 1/2" or 4'-0".

I'm looking for a way to convert this to inches and decimal points and all
the -, ', " removed.
for example 6'-5 1/2" will be 77.5 and 4'-0" will be 48

Any ideas? It's a huge spreadsheet and doing each conversion individually
will drive me nuts.

Cheers in advance

Dee

Can you format a cell to convert decimals to feet & inches
i.e. 10.250 to 10'-3"

Hello, I am currently working on cut sheets for my current project. I need to take my decimal feet (ie 1.55) and display them as feet and inches (1' 6 5/8") not (1' 6 3/5") i have a formula which is this=INT(F17)&"' "&TEXT(12*(F17-INT(F17)),"# #/#")&CHAR(34), It works but the problem is the fractional inches 6 3/5" i need them to display in 1/8 1/4 1/2 when applicable. Is there something i could add to this formula to make my inches read like a measuring tape (1' 6 5/8") 1/8 1/4 1/2??? I attached the spreedsheet for review thanks!


No luck finding an answer? You could always try Google.