---------- Forwarded message ----------
Date: Wed, 25 Aug 1999 10:45:47 -0500
From: Philip Rufe <[log in to unmask]>
To: [log in to unmask]
Subject: Decimal Degrees to DMS conversion
I wrote a spreadsheet formula to convert decimal degrees to degrees- minutes-seconds (DMS) using the Corel Quattro spreadsheet software. For the equation, 'X' represents the decimal degree value and 'Y' the DMS value.
Y=((@INT(X)*10000)+(@INT(@MOD(X,1)*60)*100)+(@MOD((@MOD(X,1)*60),1)*60))
@INT is a function which takes the integer portion of the input value.
@MOD is a function which takes the modulus of the input value.
**********************************************
Philip P. Rufe, Cartographer
USGS - MCMC Mail Stop 706
1400 Independence Rd
Rolla Missouri 65401
(573) 308 - 3540 / (573) 308 - 3652 fax
[log in to unmask]
***********************************************