convert degrees minutes seconds to radians

[Guest]

does anyone know how to convert degrees minutes seconds
to radians. I have tryed this and my number is off
significantly.

 

[Jack Schitt]

Assuming that your source is a single cell (say A1) containing a decimal
number of degrees (formatted to show minutes and seconds) then

=PI()*A1/180

should give you the radians

 

[Gord Dibben]

Assume

110:45:34 as dd:mm:ss formatted as [h]:mm:ss

=Radians(cellref)*24 returns 1.93

57.2958 degrees to a Radian.

In an earlier post I directed you to Chip Pearson's site.

Did you go there?

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

Gord Dibben Excel MVP