G Guest Sep 5, 2004 #1 does anyone know how to convert degrees minutes seconds to radians. I have tryed this and my number is off significantly.
does anyone know how to convert degrees minutes seconds to radians. I have tryed this and my number is off significantly.
J Jack Schitt Sep 5, 2004 #2 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
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
G Gord Dibben Sep 6, 2004 #3 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
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
