Closed Thread
Results 1 to 1 of 1

Macro to break-up cell and add formula

  1. #1
    Registered User
    Join Date
    london, England
    MS-Off Ver
    Excel xp

    Question Macro to break-up cell and add formula

    I have an issue that has been troubling me for sometime now.


    I have a gps system connected to an older datalogger that is streaming the data in a very un-user friendly format. It saves the gps location as degrees, and decimal minutes together in one cell, eg. -8032.117179. There are A LOT of data points so this format needs macro to clean it up.


    I am trying to create a formula that breaks apart -80 (degrees) from the rest and divides 32.117179/60 and then adds the 80 degrees back to the result.

    -8032.117179 -------> =-80.5352863

    I've tried the following


    This formula works, but because not all of the data has the same number of significant figures, it only works for a select few.

    Rounding does not seem to work.

    It would be more then great if someone knew a better way to go about this....

    Attached Files Attached Files
    Last edited by simonfoster; 06-01-2009 at 11:00 AM.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1