Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
Looking for a tool to convert DD to DMS

I have two sets of climatic lat/long point data in excel worksheets. One of them is in decimal degrees and another is in degrees/minutes/seconds. In order to integrate these 2 data to a set of excel data, first I need to change decimal degrees to deg/min/sec. Please help me how can I do this. What formula can be used to do this?

Thanks all

share|improve this question

marked as duplicate by underdark May 8 '12 at 10:11

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

You are more likely to get answers on this question if you return to previous questions and accept an answer: many answerers will see the 0% accept rate and move on to the next question. – whuber Jun 3 '11 at 22:25

1 degree = 60 minutes

1 minute = 60 seconds

share|improve this answer Under Determining Degrees, Minutes, And Seconds But for degrees you'll want to floor (likely with a -1 significance if you're in the Western Hemisphere)

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.