Converting numbers
 

What does "B6" mean in the formula after INT? Is a cell refrence?

"tamir" wrote:

To convert decimal degree (DD) to degree-minute-second (DMS) format:
DMS = TRUNC(DD)&"d " &TRUNC((DD-TRUNC(DD))*60)&"m"


&INT(((B6-TRUNC(DD))*60-(TRUNC((DD-TRUNC(DD))*60)))*60*10)/10&"s","")

which will yield DMS = 12d 7m 24.4s when DD=12.12345

a.. "Tom" wrote in message
...
Does anyone know how to convert in Excel a decimal angle
(ie 35.593056) to degrees/minutes/seconds (ie 35
minutes,35 degrees,35 seconds). Thanks for any help.

Yes it is

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"P Boric" wrote in message
...
What does "B6" mean in the formula after INT? Is a cell refrence?

"tamir" wrote:

To convert decimal degree (DD) to degree-minute-second (DMS) format:
DMS = TRUNC(DD)&"d " &TRUNC((DD-TRUNC(DD))*60)&"m"


&INT(((B6-TRUNC(DD))*60-(TRUNC((DD-TRUNC(DD))*60)))*60*10)/10&"s","")

which will yield DMS = 12d 7m 24.4s when DD=12.12345

a.. "Tom" wrote in message
...
Does anyone know how to convert in Excel a decimal angle
(ie 35.593056) to degrees/minutes/seconds (ie 35
minutes,35 degrees,35 seconds). Thanks for any help.