Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dharmik
 
Posts: n/a
Default Convert Lats and longs to decimals


I would like to know if there is a way to convert data of lats and longs
into decimals in excel.
data is already entered as 27° 13' 26.00" N
and i would like to have it as 27.xxx .
Since I have a huge amount of data I was wondering if we had function
that i could drag it for the entire column.

I tried going to cpearson website, but they require you to enter the
data in h:mm:ss form. The problem is I already have the data as 27° 13'
26.00" N.

Thanks

Dharmik


--
dharmik
------------------------------------------------------------------------
dharmik's Profile: http://www.excelforum.com/member.php...o&userid=25463
View this thread: http://www.excelforum.com/showthread...hreadid=527646

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default Convert Lats and longs to decimals

=24*SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE
(A1,"""","")," N",""),"° ",":"),"' ",":")

  #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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert lats and longs to decimals dharmik Excel Worksheet Functions 1 March 28th 06 07:12 PM


All times are GMT +1. The time now is 10:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"