how to convert from ° ' " to decimal °
 

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

how to convert from ° ' " to decimal °
 

see:

http://www.cpearson.com/excel/latlong.htm
--
Gary''s Student
gsnu200711

how to convert from ° ' " to decimal °
 

You need a function, try this one.

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

Mike

"kobbie5h" wrote:

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

how to convert from ° ' " to decimal °
 

Thanks,

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

"Gary''s Student" wrote:

see:

http://www.cpearson.com/excel/latlong.htm
--
Gary''s Student
gsnu200711

how to convert from ° ' " to decimal °
 

"kobbie5h" wrote:

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

how to convert from ° ' " to decimal °
 

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


--


Regards,


Peo Sjoblom



"timothyl" wrote in message
...


"kobbie5h" wrote:

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

how to convert from ° ' " to decimal °
 

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


"timothyl" wrote in message
...


"kobbie5h" wrote:

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