Degrees Minutes Decimal Minutes to Decimal Degrees.

A

Al

Hi All,

I have got a worksheet with cells like:

E174 36.992

I need to get that into decimal degrees like

E174.61653

Is there a way to do this with a forumla? I start with find, left,
right functions, but I ended up parenthesis hell.

Cheers

-Al
 
D

David Biddulph

=LEFT(A2)&TEXT(MID(A2,2,FIND(" ",A2)-2)+RIGHT(A2,LEN(A2)-FIND("
",A2))/60,"#.00000")
 
J

Joe User

Al said:
I have got a worksheet with cells like:
E174 36.992
I need to get that into decimal degrees like
E174.61653

One way:

=LEFT(A1,FIND(" ",A1)-1) &
TEXT(RIGHT(A1,LEN(A1)-FIND(" ",A1))/60,".00000")


----- original message -----
 
R

Ron Rosenfeld

Hi All,

I have got a worksheet with cells like:

E174 36.992

I need to get that into decimal degrees like

E174.61653

Is there a way to do this with a forumla? I start with find, left,
right functions, but I ended up parenthesis hell.

Cheers

-Al

=MID(A1,2,FIND(" ",A1)-2)+MID(A1,FIND(" ",A1)+1,99)/60

--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top