Need help converting Coordinates

[stewman]

I need help converting a large amount of coordinates form Degree Minute Decimal to Degree Decimal. For example i need 55 34.6100 x -114 41.8310 converted to 55.576833 x -114.697183. I know the math is to divide the minute.decimal by 60 and add the degree but can figure out how to get the formula to work. I attached a spreadsheet of what i am dealing with.

I appreciate any and all help.
Thanx

[shg]

In E3,

=LEFT(B3, FIND(" ", B3)) + SIGN(LEFT(B3, FIND(" ", B3))) * MID(B3, FIND(" ", B3), 16)/60

[stewman]

In E3,

=LEFT(B3, FIND(" ", B3)) + SIGN(LEFT(B3, FIND(" ", B3))) * MID(B3, FIND(" ", B3), 16)/60

worked great! thank you!

[xladept]

Hi stewman,

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name