Converting Long/Lat Decimal Degrees to Degree Minute Seconds 

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

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

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

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

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

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

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,

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

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.

Thank you very much! Very helpful tutorial!

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

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

U SAVED MY LIFE ! thank you so much

Real life saver. Thanks for this.

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

Thanks for the help. It worked perfectly!

thank you awesome job on point not too much long talk

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

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

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 ?

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

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

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

THIS IS VERY ORIGNAL AND TRUE AND EASY

Thank you so much sir

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.

Thank you so so much,

Thanks, very helpful

It worked out . Thanks a lot

Dear sir please send this xls file with formula

tq

Converting Long/Lat Decimal Degrees to Degree Min…: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uOW88OfGhDs.html

mujhe v bhejo bhai excel formula isme nhi samjha aa rha hai ki kaun sa symbol use kar rhe hai jaybabu150@gmail.com