Thread: Need to learn how to change Degre decimals into DMS
View Single Post
 
Old 11-22-2013, 10:42 PM
jolivanes jolivanes is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: Sep 2011
Posts: 91
jolivanes will become famous soon enough
Default
Either formula (Degr-Decimal) is in A1

PHP Code:
=SUBSTITUTE(TEXT(ABS(B1)/24,"[hhh] mm ss.000"),"."," ") 
PHP Code:
=TEXT(ABS(A1)/24,"[h] m' s.00''") 
Reply With Quote