You could try =LEFT(A1,3)+(MID(A1,5,6)/60) 010:43.667E ; 52:18.500N 10.72778333
Truncating the result is trivial if you need to do it Cheers Derek 人生は短いです：一日をつかむ -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Monday, 20 December 2010 9:51 AM To: [email protected] Subject: [Xcsoar-user] coordinate conversion tool? A bit off topic, though: Does any of you know a tool to batch calculate decimal degrees from the coordinates as used in the CAI format? Like this: 010:43.667E ; 52:18.500N ----becomes---> 10,7277 ; 52,3083 Excel or OO seem to have issues with it (or do I have...?). Martin --- ------------------------------------------------------------------------------ Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d _______________________________________________ Xcsoar-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/xcsoar-user ------------------------------------------------------------------------------ Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d _______________________________________________ Xcsoar-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/xcsoar-user
