I would like to write a formula in excel, without using macros, to convert

decimal feet to feet-inch-sixteenths.

Can someone help me ?

decimal feet to feet-inch-sixteenths.

Can someone help me ?

- Decimal feet to feet-inch-sixteenths conversion
- Formula for converting decimal to inch & fraction
- Convert decimal inches into feet and inches
- Formula to convert decimal ft to fractional ft
- Formula for converting decimal to inch & fraction
- Two formulas to convert between Degrees Minutes and Seconds and Decimal Degrees
- Formula to Convert Coordinates
- Formula to convert custom date to number
- How to convert decimal numbers to time format
- How to convert decimal values (dd.dddddd) to degrees/minutes/seco.
- Any formula to convert numbers in word form, e.g. "2" as "Two"?
- Convert decimal degree (lattitude/longitude) into Degree,
- Is there a formula to convert numbers to written text in Excel?
- Formula to convert unit?
- How to set a formula to convert the time zone
- Formula to convert times.
- Formula to convert PST into IST (Time)
- How do I create a formula to convert kilograms to pounds
- How to convert decimal numbers to words
- Convert decimal degree (lattitude/longitude) into Degree,
- Converting from feet, inches and fractions to inches and decimal p
- Convert decimals to feet / inches in excel
- Convert Decimal Feet to Feet and Inches

convert decimal feet to feet-inch-sixteenths. (ex. 4.5417 to 4-6-8)

can anyone help me with this

I am using Excel 2000.

Thank you for your help.

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

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?

I am using Excel 2000.

Thank you for your help.

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.

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??

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

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 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

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.

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

to convert in English. For example, I am trying to convert "123" into "one

hundred and twenty three". Can anyone help me?

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.

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.

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

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.

ONE THOUSAND AND TWENTY FOUR. IS THIS POSSIBLE???

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

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