Calculating Radians When the Degrees Include Minutes & Seconds (SS)

This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.
The Radians function in ClarisWorks converts an angle measurement given in degrees into radians (the standard unit used in trigonometric functions). This function has one argument, or variable, which is the number of degrees and fractions of a degree expressed as a decimal number. If your angle measurements are expressed in degrees, minutes, and seconds, you must convert these numbers to a single decimal number within your formula in order to convert it to radians.

The following formula will do this. It assumes the degrees are in column B, the minutes in column C, the seconds in column D, and that you want to calculate the radians in column E:

E1=RADIANS(B1+(C1/60)+(D1/3600))
Published Date: Feb 18, 2012