+ Reply to Thread
Results 1 to 5 of 5

How do I enter degrees, minutes, seconds

  1. #1
    Edwn
    Guest

    How do I enter degrees, minutes, seconds

    I have an excal project that requires me to use degrees, minutes and seconds.
    How do I enter this into a cell

  2. #2
    jennifer
    Guest

    RE: How do I enter degrees, minutes, seconds

    For the degrees go to insert menu and select symbol; make sure your font says
    symbol and locate the degree symbol, press enter.
    For the time, go to format menu and select cells, press the number tab and
    select time and find the format you want to use.

    "Edwn" wrote:

    > I have an excal project that requires me to use degrees, minutes and seconds.
    > How do I enter this into a cell


  3. #3
    JulieD
    Guest

    Re: How do I enter degrees, minutes, seconds

    Hi Edwn

    for a good explaination on the topic check out
    http://www.cpearson.com/excel/latlong.htm

    Cheers
    JulieD

    "Edwn" <Edwn@discussions.microsoft.com> wrote in message
    news:2880FBB5-9D13-4E38-92F3-5E73090C6872@microsoft.com...
    >I have an excal project that requires me to use degrees, minutes and
    >seconds.
    > How do I enter this into a cell




  4. #4
    Registered User
    Join Date
    03-16-2005
    Posts
    7
    I just ask for the date in three cells putting "Degrees? " in (say) A1, "Minutes? ",in A2, and "Seconds? " in A3 with the data entered in B1, B2, B3 respectively. (Later of courrse you will lock all the cells except the ones in which data is to be entered). Then in another cell put "=A1+B1/60+C1/3600". If you are talking latitude and longitude you will ask "N or S?" in A4 and get the answer in B4. Then (assuming the last calculation was done in C1) write in D1 "IF (UPPER(C1))="S".-C1,C1" to get a negative figure if the latitude is Southern. Depending on how bright the users will be you may want to validate the input!

  5. #5
    AlfD
    Guest

    Re: How do I enter degrees, minutes, seconds

    Hi!

    When you have formatted a cell as [h]:mm:ss, enter your data as, for
    example, 12:48:06.
    You will then find you can calculate using the contents of the cell
    (addind, multiplying etc).


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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