need to convert decimal degrees to degrees, minutes, hundreds

  • Thread starter Formula request
  • Start date
F

Formula request

i am trying to get the formula to change decimal degrees to degrees, minutes,
hundreds or to degrees minutes, thousands.

Any help would be appreciated.
 
J

John Vinson

On Mon, 8 May 2006 16:39:01 -0700, Formula request <Formula
i am trying to get the formula to change decimal degrees to degrees, minutes,
hundreds or to degrees minutes, thousands.

Any help would be appreciated.
Click to expand...

Fix([degrees]) & " deg " & Format(60 * ([degrees] - Fix([degrees]),
"00.000") & " min"

John W. Vinson[MVP]
 
Top