need to convert decimal degrees to degrees, minutes, hundreds

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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]
 
Back
Top