Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
Converting time to numbers | Excel Discussion (Misc queries) | |||
converting dates into numbers | Excel Discussion (Misc queries) | |||
Converting text to numbers | Excel Discussion (Misc queries) |