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