ExcelBanter - decimal to degree min sec

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - decimal to degree min sec (https://www.excelbanter.com/excel-discussion-misc-queries/19297-decimal-degree-min-sec.html)

Zainelabdin

decimal to degree min sec

Howto convert from decimal e.g 125.2356 to Deg Min Sec

John Mansfield

Zainelabdin,

Enter them in time format i.e. DD:MM:SS

For more explanation, see

http://www.cpearson.com/excel/latlong.htm

----
Regards,
John Mansfield
http://www.pdbook.com

"Zainelabdin" wrote:

Howto convert from decimal e.g 125.2356 to Deg Min Sec

All times are GMT +1. The time now is 10:34 PM.