how to convert from ° ' " to decimal °

[kobbie5h]

Is there a simple way to convert from angles in degrees, minutes and seconds
to decimal degrees?
eg 45°30'00" = 45.5°

 

[Gary''s Student]

see:

http://www.cpearson.com/excel/latlong.htm

 

[Mike]

You need a function, try this one.

http://support.microsoft.com/kb/213449

Mike

 

[kobbie5h]

Thanks,

It's so simple I forgot how to do it.

 

[timothyl]

Is there a simple way to convert from angles in degrees, minutes and seconds
to decimal degrees?
eg 45°30'00" = 45.5°

 

[Peo Sjoblom]

http://www.cpearson.com/excel/latlong.htm


--


Regards,


Peo Sjoblom

 

[Rick Rothstein \(MVP - VB\)]

If you are talking about "in another cell", then this formula seems to do
what you want...

=LEFT(A1,FIND(CHAR(176),A1)-1)+24*TIME(0,--MID(A1,LEN(A1)-5,2),--MID(A1,LEN(A1)-2,2))

Rick