User Profile
weikiat98
Copper Contributor
Joined Jun 09, 2023
User Widgets
Recent Discussions
formula to convert degree minutes to degree decimals
Hello all, is there a better formula to convert degree minutes to degree decimals in excel? The formulas I currently use produce some inconsistencies coordinate points on my map. Refer to picture and formulas below for reference. The current formula I use for Latitude in context of cell N2: =IF(OR(RIGHT(L2,1)="S", RIGHT(L2,1)="s"), -1, IF(OR(RIGHT(L2,1)="N", RIGHT(L2,1)="n"), 1, "")) * (VALUE(LEFT(L2, FIND("-", L2)-1)) + (VALUE(MID(L2, FIND("-", L2)+1, LEN(L2)-FIND("-", L2)-1)) / 60)) Longitude formula in column O using cell M2: =IF(RIGHT(M2,1)="W", -1, 1) * (VALUE(LEFT(M2, FIND("-", M2)-1)) + (VALUE(MID(M2, FIND("-", M2)+1, LEN(M2)-FIND("-", M2)-1)) / 60)) Thanks
