Hey guys. I have a little problem I've been trying to wrap my head around. I'm not an excel expert, so I thought I'd come look for some help. I'm trying to create a spreadsheet that will convert coordinates from DDMMSS.00 to DDMM.000. I found another thread that discusses this same issue, but I was unable to make it work for me. I'm attaching a sample spreadsheet that basically shows what I'm trying to do. Let me know if there's any more info ya'll need.
Chris
Last edited by batorizer; 01-08-2009 at 10:48 AM.
Welcome to the forum.
Wouldn't plain decimal degrees be easier if you're doing any downstream calculation?
Entia non sunt multiplicanda sine necessitate
Never mind ...
=INT(LEFT(A2, LEN(A2)-1)/100) + MOD(LEFT(A2, LEN(A2)-1), 100) / 60
For latitudes, format as 0.000"N";0.000"S"
For longitudes, 0.000"W";0.000"E"
Thank you sir, the formula works perfectly and you've helped me avoid some writers cramp.
Luckily, I've got software that does all the calculations. As for this spreadsheet, it's one of the final steps in the process and is used mainly for documentation.
You’re welcome. Would you please mark the thread as Solved?
Click the Edit button on your first post in the thread
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
I've got another quick question for ya. I've entered the cell format like you have it, but I can only get N or W to show. Is there any way to make the hemisphere in the cell format of the computed cell dependant on which hemisphere I've used originally?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks