Thread: Convert Lats and longs to decimals
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default Convert Lats and longs to decimals
Or for those Down Under
=SUBSTITUTE(SUBSTITUTE
(LEFT(A1,LEN(A1)-3),"° ",":"),"' ",":")*24*
IF(OR(RIGHT(A1,1)="S",RIGHT(A1,1)="W"),-1,1)

Reply With QuoteReply With Quote