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

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

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

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?

--

Regards,
Nigel




"Asa_johannesen" wrote in message
...
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

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

Hi Asa,

Look he

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

It's the 4th item

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Asa_johannesen" wrote in message
...
| 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