Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

2 Answers 2

1 degree = 60 minutes

1 minute = 60 seconds

share|improve this answer

http://www.cpearson.com/excel/LatLong.aspx 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.