Can this be done in Excell

Posted to microsoft.public.excel.misc

Posts: n/a

Can this be done in Excell

I have two columns with the following format:
Long Lat
97-31-10.2 W 25-57-51.2 N

So i need to change this format(Minutes-Degee-Sec) to Decimal Degrees.

So from the first column Long:
(97/3600)+(31/60)+10.2=97.5195.This is the number in Decimal degree for Long.

Can this be automated in Excell ?

Regards
Rick

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Can I view an excell document without excell (not installed wit.	Gordon	Excel Discussion (Misc queries)	8	May 2nd 06 05:41 AM
insert query into excell sheet to update excell sheet and pivot table	vbsolo	Excel Discussion (Misc queries)	0	August 24th 05 12:41 PM
Can I view an excell document without excell (not installed wit.	Kevin	Excel Discussion (Misc queries)	1	February 16th 05 08:27 PM
lable ranges in Excell	david	Excel Discussion (Misc queries)	2	February 2nd 05 11:26 PM
EXCELL 2002 Glitch????	Gabriel20783	Excel Discussion (Misc queries)	1	November 29th 04 08:55 PM

All times are GMT +1. The time now is 02:34 AM.

Menu

About Us