# Convert Degrees Minutes & Decimals Of A Minute (12° 34.567') To Degrees And Decimals Of A Degree (12.57611°)

Oct 29, 2008
I am trying to convert Degrees Minutes & Decimals of a minute (12° 34.567') to Degrees and decimals of a degree (12.57611°). I have the formula to convert latitude, that is two digits, but it doesn't want to work with longitudes, three digits. (see attachment). This is the formula that I am using:

=IF(A2="","",(INT((LEFT(A2,3)+MID(A2,4,6)/60)*100000)/100000)&"d")

View 2 Replies
ADVERTISEMENT
Nov 1, 2008

I had a similar problem a day or two ago in converting Deg Min.dec to Deg.dec and it has happened again. This time I want to convert Degrees Minutes & Seconds to Degrees.decimals.

The formula I am using works for a two digit number Lat. but not 3 Long.?? Here it is below:

=+IF(A2<>"",INT((LEFT(A2,3)+MID(A2,4,2)/60+MID(A2,7,4)/3600)*100000)/100000&"d","")

View 7 Replies
View Related
Sep 16, 2007

Need to convert decimal degrees into degrees, minutes, & seconds (displayed in three columns). Currently calculated manually from ATAN, ASIN, or ACOS functions.

View 5 Replies
View Related
Nov 17, 2006

how would you take decimals to dms, and also how to put dms into the right bearings?

Reference: Covert degrees, minutes and seconds to decimal degrees

View 4 Replies
View Related
Sep 16, 2013

I have degree values as this 4145.5

Which is 41 degrees 45.5min

and 0010.2

Which is 0 degrees 10.2min

I need 4145.5 and 0010.2 to be converted to decimals so that I can add and subtract them

Then the answer needs to be converted back into

a format like this

45Â° 45.5'

View 4 Replies
View Related
Dec 9, 2008

I've writing excel formulas to convert Decimal Degrees (DD) to Degrees Minutes and Seconds (DMS) and back again for astronomy. These are for converting DD angles for telescope Right Ascension (RA) and Declination Angles (DEC) pointing.

I've got the formulas to work except for one minor annoyance. Try this formula for converting DEC DD angle of -1.5° to a DEC DMS angle: ....

View 9 Replies
View Related
Sep 16, 2007

Need to convert decimal degrees into degrees, minutes, & seconds (displayed in three columns). Currently calculated manually from ATAN, ASIN, or ACOS functions.

View 4 Replies
View Related
Nov 21, 2013

I have a data set that expresses time in hours and minutes but it can only be exported like so:

7h10

11h03

Any function I could use to convert those numbers into 7.6 or 11.03?

View 3 Replies
View Related
Nov 14, 2009

How do I custom format a cell to display degrees minutes seconds. I now there is a way. I found in on the web once but can not find it again. The formating from cpearson does not work the way i want.

For example if in cell a1 I input 50.2536, I want to to format the cell as 50° 25' 36". opefully this can be applished without any formulas. Either soem code or formating would be great. The last time I found it I thought it was something like ###° ??'/??" but that did not work. Thanks in advance. The reason I need it, is to use the convert_decimal function I found on the microsoft website.

View 9 Replies
View Related
Jun 11, 2007

I have a column in excel which includes numbers like (12 13 14.5), and I want to format like this (12 Degree Sign, 13 Minute Sign, 14.5 Second Sign).

View 9 Replies
View Related
May 29, 2013

The problem I am having is in trying to make a custom cell format for inputting my data. I want it to appear as 44Â° 41' 5" (in the same cell). I would like the cell to function so that if im inputting data manually for it to automatically put in the appropriate (degree,minute or second marks). That way I could just enter somthing like 44 41 5 and it display properly. Also I am trying to keep the data in text format for another marco I am running to convert the DMS data into decimal.

View 2 Replies
View Related
Jul 6, 2011

i am trying to finish a spreadsheet off using cos functions. I want to convert 26 degrees into 0.8988. when i use my hand calculator i type 26 in then press cos and it converts it to 0.8988 which is correct, but when i try to use the excel cos function it gives 0.646919322 which is in-correct.

View 5 Replies
View Related
Jan 23, 2007

How can I show a decimal as time. For example an item takes 13 minutes to make and I want to make 50, thus using 6.5 hours but really, the 0.5 hours is 30 minutes therefore, I would like to show 6:30 but Excel gets to 23:59 and goes back to 0:00.

View 9 Replies
View Related
Jun 12, 2013

I'm trying to convert degree minutes and second latitude and longitude to decimal lat and long in excel (I have 100s of such conversion to undertake). When trying out dividing the minutes and second by 60 and checking my calculation on Google Maps lat/long finder or Latlong.net my calculations are not correct. However the equation to other way around - converting from decimal lat long to DMS (*60) works.

View 2 Replies
View Related
Nov 19, 2008

1.25 is in cell A1. This number will often be buried in a longer part number that may look like ELL-1.25-S40.

I would like to use a formula in cell A2 to display the fractional equivalent (1-1/4).

View 9 Replies
View Related
Nov 11, 2008

I have a spread sheet with over 200 numbers like 3.3, 4.5, 6.6 and so on. Is there and easy way to convert them to Percentages?

View 2 Replies
View Related
Nov 16, 2006

I need help shrinking down my formula to make it fit in one cell.

Right now, the way i have it, it spans across (7) different cells to get the results i desire. Is there a way i can make this shorter?

A11 – This is where the decimal value of a number is inputted.

B11 – This is the final display after running A11 through the formulas below

Here are my formulas: ...

View 9 Replies
View Related
May 29, 2007

When exporting a set of historical sports results to Excel 2003 the numeric odds are converted to a date eg 7/2 changes to 07-Feb. Can this be prevented or adjusted to retain the original data.

Also if I may ask can the UK style odds be converted to a decimal style. Eg. 7/2 (UK) needs to be converted to 4.5 ( Decimal equivalent )

View 9 Replies
View Related
Jul 14, 2014

I have a list of numbers with decimals : such as

742111.37

703102.4

641771.52

652689.31

741202.92

I would like to convert the Numeric values to Text

Result :

Seven Hundred Forty Two Thousand One Hundred and Eleven and Thirty Seven .....

..........

..........

and so on....

View 1 Replies
View Related
Feb 6, 2009

I know that if I enter =3/4 in a cell it will give me .75 but is there is formula to convert fractions into decimals or is this the best way to do it? I was also wondering if there is some way to convert the decimal amount to a fraction

for measurement conversions I know that

=B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")

and to convert mm to a decimal a few formula that work are

=CONVERT(H3,"mm","in")

=MROUND(H4/25.4, 1/8)

=H5/25.4

=INT(H6/25.39999918*8)/8

But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction?

or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?

View 4 Replies
View Related
Jan 14, 2009

I am creating a very quick holiday excel sheet where people can fill in the hours they want on which days.

I have a summery sheet too.

So if someone wants to take a full day which is 7.4 hours. How would this be represented as Hours and minutes?

View 9 Replies
View Related
Apr 28, 2006

Working on a project and using a formula like this just so we can get the degree sign:

=TEXT(ROUND(DEGREES(ATAN2((C6-C30)/2,A25)),1),"0.0")&CHAR(176)

This obviously results in a text value.

How can I dump the TEXT function and the CHAR function and format the cell to display the degree sign and still be a numeric data type?

View 9 Replies
View Related
Jun 12, 2007

I have a spreadsheet that is so long ie columns that i have decided to flip it over so that my old row titles are now column headings and my column heading are now row titles.

The reason for this is that I need to enter more that 256 columns into my worksheet matrix and I only have 209 rows thus light bulb moment turned the whole spreasheet 90 degrees within the worksheet!

View 9 Replies
View Related
Feb 13, 2009

I am trying to work out how to convert the slope/gradient from degrees to %, and ratio.

View 7 Replies
View Related
Feb 23, 2012

How do I rotate sheet tabs 90 degrees?

View 1 Replies
View Related
Jul 23, 2013

I have a label in a userform which is picking up data from sheet1.range("a1") and i would like it to show along the left side of the userform so rotated at 90 degrees.

I do not have to use a label but I do need the data to be shown at 90 degrees.

View 4 Replies
View Related
May 12, 2014

I have created a table in Excel that I want to import in a word portrait page, but would like to rotate it to 90 degrees.

I would like the table to take the whole page and that I still have some space above the table to put table number and description.

I have uploaded the table in excel and a screenshot of the way I would like the table to appear in word file.

View 6 Replies
View Related
Jul 17, 2014

I am creating a graph with a wide range of values (0.06 - 300). The smaller values are barely visible on my column graph. I have tried all of the tricks I know. Any way to get the smaller values to show up instead of just hovering towards the bottom of the graph?

View 9 Replies
View Related
Oct 14, 2009

I am trying to get an exact ratio in excel but am unable to do so. Example:

60,000/58000 = 1.03. The ratio should then be 1.03:1. But excel is showing this is 1:1. Here is my formula

PHP

=TEXT(E55/E56,"0")&":1" . I need it to show it to two decimals.

View 2 Replies
View Related
May 23, 2014

I have some problem when I would like to sum only positive decimals on userform, I would like to separate the numbers with comma (",") and sum them, the format should be "0,0" and only numbers and "," can be given in textboxes. How should I do this?

View 3 Replies
View Related