Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Need formulae to convert decimal degree (lattitude/longitude) into Degree,
Minutes, Seconds format. I have the following: Lattitude data of 0.1741463938 and to convert to decimal degrees, I muliply by 180 which gives me decimal degrees of 31.3463508840. Now I need to convert to a Degree, Minute, Seconds format (N34* 50' 56.04"). Note: the '*' represents the 'degree' symbol - did not know how to display the symbol. Need to also display whether 'N' (North) or 'S' (South) based on actual coordinate. For Longitude, I have data of -0.4758427618 *180 = -85.6516971240 (decimal degrees) and need to also convert to Degree, Minute, Seconds format (W16* 40' 23.54"). Note: the '*' represents the 'degree' symbol - did not know how to display the symbol. Need to also display whether 'W' (West) or 'E' (East) based on actual coordinate. The formulae needed will take the original lat/long data, multiplied by 180, and then ???? applied to deliver the data in Degrees, Minutes, Seconds format. Thank you very much for your assistance. Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
Convert degree from decimal number to the standard format (degre. | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
How to convert decimal values (dd.dddddd) to degrees/minutes/seco. | Excel Worksheet Functions |