Converting Long/Lat Decimal Degrees to Degree Minute Seconds

[@ProStreetFalcon1]

I have watched many, many TH-cam videos. This video is by far, the most AWESOME video i have ever watched. GREAT job & Thank You. Jerome

[@bernardperrier2430]

Magnifique, ca faisait longtemps que je chercher cela, en fin trouver, sublime, j'ai reussi a faire le mien depuis mon gps et google earth. Chapeau bas Monsieur Moulay

[@sounny]

Je vous en prie

[@bernardperrier2430]

@@sounny Bonjour, merci bien d'avoir repondu, petit souci faire la faire, la formule refuse de s'executer=CONCATENATE(A2," ",B2," ° ",C2," ' ",D2,"""), pouvez vous m'aider s'il vous plait

[@bernardperrier2430]

Merci bien , j'ai pu trouver la solution, ai fait la formule dans une autre case et ca a marcher, donc j'ai pu copy paste. En tout les cas merci bien

[@PixlPath]

Thanks for this eight years later. Was having trouble converting camera gps metadata.

[@sounny]

happy to hear.

[@montyengreint]

This is very useful, true and real. Very easy and its really an eye opening to me. Thank you

[@CarloNyte]

Dude!! You're an absolute life saver! This was so damn helpful! Thank you for making this

[@mavericknisha7316]

simply amazing. loved it because i can use it any way i want. Most imp. it worked .

[@anulisaclaire7263]

Lovely. helped me with my work. Thanks for posting.😊

[@royd7636]

I think it's much easier to create a user defined function:
1) Alt-F11 to open Visual Basic Editor
2) Right click the workbook name on the left and select Insert, Module
3) Copy and paste the code below
4)Click Debug from the menu bar and select "Compile VBA Project"
5) When you save the workbook you must save it as a .xlsm (macro).
______________________________________________________________________________________
Function GetMinSec(CellRef As Double)
Dim Degrees As Double
Dim Minutes As Double
Dim DecMinutes As Double
Dim Seconds As Double
Dim DecSeconds As Double
Dim Answer As String
' get rid of negative and strip decimal
Degrees = Abs(Fix(CellRef))
' process minutes and seconds
' get decimal minutes
DecMinutes = Abs(CellRef) - Degrees
' get total minutes
DecMinutes = DecMinutes * 60
Minutes = Fix(DecMinutes)
' get total seconds
Seconds = (DecMinutes - Minutes) * 60
' concatenate variables
Answer = Degrees & Chr(176) & " " & Minutes & "' " & Round(Seconds, 2) & """"
GetMinSec = Answer
End Function
_____________________________________________________________________________________
Just enter "=GetMinSec(cellref) and that's it. I didn't bother dealing with the north, south, east, west and negative coordinates because all my numbers were for North America.

[@petberealcool]

u can use Trunc function then make the difference to obtain the remaining and get rid of the Text to columns stuff :)

[@ruthpalsson6930]

Thanks so much for this idea!!

[@ryanwilson7175]

This tutorial save me a lot of time, thank you!

[@destyadinirndini2859]

llkk

[@michaelmcnulty8785]

Real life saver. Thanks for this.

[@varunsandesh4914]

Thank you so much sir

[@Clau0720]

Thank you very much! Very helpful tutorial!

[@OwdLarrd]

Any suggestions for a last HowTo refinement, please? After concatenation, taking the results to the stricter formal format! e.g.
W 2° 39' 20.8908"
to be auto-formatted into the next right hand empty column to
W 002° 39' 21"
Regardless of a reply, thank you for the tutorial as-is. There are some Excel functions in there that I hadn't used before,

[@Praveen_Shiva_Kumar_Bhat]

Thank you very much for the video saved my lot of time and effort.

[@avaneedubey5749]

you are amazinggggg!!!!!!!!!!!!!

[@bbbbbbbbbb434]

U SAVED MY LIFE ! thank you so much

[@sounny]

Converting Long/Lat Decimal Degrees to Degree Min…: th-cam.com/video/uOW88OfGhDs/w-d-xo.html

[@Mohanad52023]

good job .. awesome explanation .. many thanks Mr. ...

[@vuminhthieu1778]

Thank you so so much,

[@PradeepKumar-ee7cw]

THIS IS VERY ORIGNAL AND TRUE AND EASY

[@kensawh]

thank you awesome job on point not too much long talk

[@mattcrawford6948]

Thanks for the help. It worked perfectly!

[@handisridho]

Thanks, very helpful

[@laurenware9817]

Would it be possible to also show us how to convert decimal (lat/long) to just degree minutes format? The hobby geocaching just uses degree minutes so it would be great to be able to convert a list of 50+ decimal coordinates into decimal minutes.

[@bernardperrier2430]

hi, very easy, mine too was in decimal minutes

[@laurenware9817]

@@bernardperrier2430 since easy, can you tell me how to do it? Many thanks.

[@bernardperrier2430]

Hi, please send a email address

[@bernardperrier2430]

S 20 35.805 E 57 45.780
Is it this style you are looking degree, minutes, decimal minutes

[@laurenware9817]

Bernard Perrier yes that is it.

[@finehasvenance]

It worked out . Thanks a lot

[@ahasan9005]

would any one please write how did he insert the degree symbol? I didn't understand the part after press and hold Alt key...

[@ACLEnvironment]

tq

[@marceloverganio4682]

the video is blurry, can't see, can you make another?

[@densherpa]

When I put formula my value comes as N34d56'45.77665432178"E, how to convert value in 45.77"?

[@stefaniamates6453]

Format cells

[@Bobyoann]

Lorsque j arrive à faire les multiplication par 60 il inscrit #valeur! Exemple: (0.6773*60). Lorsque je met une virgule au lieu d un point le calcul fonctionne (0,6773*60) comment faire svp ?

[@rohitteotia9342]

Dear sir please send this xls file with formula

[@rventerprises8799]

mujhe v bhejo bhai excel formula isme nhi samjha aa rha hai ki kaun sa symbol use kar rhe hai
[e-mail]