MS Excel: Converting Decimal Degree (DD) to Degree-Minute-Second (DMS)

Using the most simple software but still maintain the effectiveness of the procedure is our preference in doing GIS operations. MS Excel, even this software is designed for spreadsheet operation, because of its widely used and simpler software is still used for some GIS analysis especially for reporting. This tutorial shows us how to use MS Excel to convert decimal degree (DD) into degree-minute-second (DMS) without any GIS software

The picture above shows our DD unit which are going to be converted into DMS

1. Prepare some headers (FIELDS) DMS for each X and Y. I suggest you to use such DX, MX, SX, DY, MY, dan SY header as shown in the following image

   

2. Fill DX value with degree from LON. We need to round it down as shown by formula in the following image.

   

3. Fill MX value with minute for LON. We need to do a substraction (LON – DX) and then convert the value into minutes by multiplication with 60 as shown below.

   

   Search :

   rumus desimal, pengertian dms, konversi desimal ke derajat, derajat menit detik, konversi dd ke dms,