Urgent please help

  • Thread starter Thread starter Absynth
  • Start date Start date
A

Absynth

I have to conevert a column of data in excel from degrees minute seconds
(DMS) to decimal degree.. And excel only accepts data in form of dd mm ss and
my data is in format ddmmss.. theres just too much data to do it manually..
Can anyone help me find any function which allows to insert spaces in my
format.
Thanks..
 
Say A1 has:
451215
meaning 45 degrees, 12 minutes, 15 seconds. In B1 enter:

=LEFT(A1,2)+MID(A1,3,2)/60+RIGHT(A1,2)/3600
to display:

45.20416667
 
Back
Top