Converting a GPS waypoint from decimal to degrees, minutes and sec

[Asa_johannesen]

Hi.

Can anyone help me? I have a GPS waypoint in decimal, and I need to convert
it to degrees etc. I have a formula I found online, but it doesn't work. I
don't know excel well enough to see where the error is so I'll paste it here.
Either way, if someone knows a formula for doing the conversion, I'd be very
grateful if you could post it here.

DMS = TRUNC(DD)&",d ", &TRUNC((DD-TRUNC(DD))*60)&",m",
&INT(((B6-TRUNC(DD))*60-(TRUNC((DD-TRUNC(DD))*60)))*60*10)/10&",s",,",",)

Thank you.

Asa

 

[Nigel]

Are you substituting DD with the cell reference containing the decimal value
or are you naming the cell with the value and calling it DD ?

and the DMS must be referenced as a cell or named range.

This maybe why it does not work?

 

[Niek Otten]

Hi Asa,

Look here:

http://www.cpearson.com/excel/latlong.htm

It's the 4th item

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi.
|
| Can anyone help me? I have a GPS waypoint in decimal, and I need to convert
| it to degrees etc. I have a formula I found online, but it doesn't work. I
| don't know excel well enough to see where the error is so I'll paste it here.
| Either way, if someone knows a formula for doing the conversion, I'd be very
| grateful if you could post it here.
|
| DMS = TRUNC(DD)&",d ", &TRUNC((DD-TRUNC(DD))*60)&",m",
| &INT(((B6-TRUNC(DD))*60-(TRUNC((DD-TRUNC(DD))*60)))*60*10)/10&",s",,",",)
|
| Thank you.
|
| Asa