View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Fri, 8 Apr 2005 21:23:03 -0700, George
wrote:

Can excel read numbers in the Sexagesimal system (DMS)?


So long as you use the decimal separator, Excel can convert your input to the
decimal equivalent.

If you have the Analysis ToolPak installed, you could use the DOLLARDE
function. e.g.

=DOLLARDE(A1,60).

If you do not have the ATP installed, then

=INT(A1)+MOD(A1,1)/0.6


--ron