convert degrees minutes seconds to radians

#1 September 5th, 2004, 11:31 PM

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

#2 September 5th, 2004, 11:48 PM

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

--
Return email address is not as DEEP as it appears
wrote in message
...
does anyone know how to convert degrees minutes seconds
to radians. I have tryed this and my number is off
significantly.

#3 September 6th, 2004, 12:09 AM

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

On Sun, 5 Sep 2004 15:31:05 -0700,
wrote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Degrees Minutes and Seconds	Yosof Ewing	Worksheet Functions	5	August 12th, 2004 04:43 PM
enter an angle in degrees minutes seconds (dms) into spreadsheet	hartr	Worksheet Functions	1	August 12th, 2004 03:24 PM
Degrees minutes seconds to degrees	M Alzahri	Worksheet Functions	1	July 23rd, 2004 05:15 AM
Converting minutes & seconds to total seconds	JE McGimpsey	Worksheet Functions	2	May 31st, 2004 11:36 PM
Degrees Minutes Seconds conversion	Joe	Worksheet Functions	3	January 9th, 2004 02:41 AM