Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to convert decimal values (dd.dddddd) to degrees/minutes/seco.
I would like to convert decimal values (-33.654873) to degrees/minutes/seconds
I am looking for an automatic function to do this. -33.654873 = -33 degrees 39 minutes (0.654873*60 = 39.29238) 18 seconds (0.29238 * 60 = 17.54) Is there a way to do this autmatically? Kind regards, Florin Balcu Perth, Western Australia |
#2
|
|||
|
|||
Florin, Nice to hear that Perth is getting a mention. Look at http://www.cpearson.com/excel/latlong.htm for lots on tips on this type of conversion to/from DMS. -- Kieran Born ignorant and still perfecting the art ------------------------------------------------------------------------ Kieran's Profile: http://www.excelforum.com/member.php...fo&userid=1247 View this thread: http://www.excelforum.com/showthread...hreadid=277622 |
#3
|
|||
|
|||
Using your example you could use
=TRUNC(A1)&CHAR(176)&TEXT(MOD(ABS(A1),1)/24," mm:ss") in general you can find a lot of info here http://www.cpearson.com/excel/latlong.htm -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Florin Balcu" <Florin wrote in message ... I would like to convert decimal values (-33.654873) to degrees/minutes/seconds I am looking for an automatic function to do this. -33.654873 = -33 degrees 39 minutes (0.654873*60 = 39.29238) 18 seconds (0.29238 * 60 = 17.54) Is there a way to do this autmatically? Kind regards, Florin Balcu Perth, Western Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Second serie doesn't use X-as values | Charts and Charting in Excel |