| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Degrees Minutes Decimal Minutes to Decimal Degrees.
Hi All,
I have got a worksheet with cells like: E174 36.992 I need to get that into decimal degrees like E174.61653 Is there a way to do this with a forumla? I start with find, left, right functions, but I ended up parenthesis hell. Cheers -Al |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Degrees Minutes Decimal Minutes to Decimal Degrees.
"Al" wrote:
I have got a worksheet with cells like: E174 36.992 I need to get that into decimal degrees like E174.61653 One way: =LEFT(A1,FIND(" ",A1)-1) & TEXT(RIGHT(A1,LEN(A1)-FIND(" ",A1))/60,".00000") ----- original message ----- "Al" wrote in message ... Hi All, I have got a worksheet with cells like: E174 36.992 I need to get that into decimal degrees like E174.61653 Is there a way to do this with a forumla? I start with find, left, right functions, but I ended up parenthesis hell. Cheers -Al |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Degrees Minutes Decimal Minutes to Decimal Degrees.
=LEFT(A2)&TEXT(MID(A2,2,FIND(" ",A2)-2)+RIGHT(A2,LEN(A2)-FIND("
",A2))/60,"#.00000") -- David Biddulph "Al" wrote in message ... Hi All, I have got a worksheet with cells like: E174 36.992 I need to get that into decimal degrees like E174.61653 Is there a way to do this with a forumla? I start with find, left, right functions, but I ended up parenthesis hell. Cheers -Al |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Degrees Minutes Decimal Minutes to Decimal Degrees.
On Thu, 18 Mar 2010 01:05:18 -0700 (PDT), Al wrote:
Hi All, I have got a worksheet with cells like: E174 36.992 I need to get that into decimal degrees like E174.61653 Is there a way to do this with a forumla? I start with find, left, right functions, but I ended up parenthesis hell. Cheers -Al =MID(A1,2,FIND(" ",A1)-2)+MID(A1,FIND(" ",A1)+1,99)/60 --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Decimal Degrees to Degrees/Minutes/Seconds | Excel Worksheet Functions | |||
| How do you convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| how can i convert degrees/minutes/seconds to decimal degrees? | Excel Discussion (Misc queries) | |||
| Convert degrees at 'Minutes' format. i.e. 43° 22', to Decimal | Excel Discussion (Misc queries) | |||
| convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
![Al[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
