The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Using the d,m,s system as numbers in Excel 2007/2010

    Discussion in 'Windows OS and Software' started by JCMS, Nov 21, 2009.

  1. JCMS

    JCMS Notebook Prophet

    Reputations:
    455
    Messages:
    4,674
    Likes Received:
    0
    Trophy Points:
    105
    For my lab report on hydrogen's spectral series, I need to use degrees/minutes (my measures are in that). How can I use this system in Excel? My friend was able to in OpenOffice so it should be in Office 2007/2010...

    Thanks
     
    JCMS, Nov 21, 2009
    #1
  2. DetlevCM

    DetlevCM Notebook Nobel Laureate

    Reputations:
    4,843
    Messages:
    8,389
    Likes Received:
    1
    Trophy Points:
    205
    One thing I could think of is witing a visul basic macro...

    Or right click a cell, -> format cells -> and have a look there, but I was unsuccessful.
     
    DetlevCM, Nov 21, 2009
    #2
  3. JCMS

    JCMS Notebook Prophet

    Reputations:
    455
    Messages:
    4,674
    Likes Received:
    0
    Trophy Points:
    105
    Hmm. I think I'll just do a side table with the values in decimals and then do the excel calculations through it.

    Since it's there natively in OO, I'm it is in MSO, just need to find it....hard thing to do haha
     
    JCMS, Nov 21, 2009
    #3
  4. DetlevCM

    DetlevCM Notebook Nobel Laureate

    Reputations:
    4,843
    Messages:
    8,389
    Likes Received:
    1
    Trophy Points:
    205
    DetlevCM, Nov 21, 2009
    #4
  5. JCMS

    JCMS Notebook Prophet

    Reputations:
    455
    Messages:
    4,674
    Likes Received:
    0
    Trophy Points:
    105
    Ok thanks for the input. My calculator has the convert function so I'll check which one is quicker. I may also try using the values as a time format since both are in base 60
     
    JCMS, Nov 21, 2009
    #5
  6. DetlevCM

    DetlevCM Notebook Nobel Laureate

    Reputations:
    4,843
    Messages:
    8,389
    Likes Received:
    1
    Trophy Points:
    205
    The advantage of writing a macro is that you can batch convert a large amount of data in Excel.
     
    DetlevCM, Nov 21, 2009
    #6