Posted to microsoft.public.excel.misc
|
|
how to add degree,minutes and seconds
Check out this link...
http://www.cpearson.com/excel/latlong.htm
--
HTH...
Jim Thomlinson
"Bal" wrote:
i wanted to 23 degree 34 minutes and 51 seconds on 12:23:34 but results come
out as hh:mm:ss only less than 24 hour figure. how can i work on adding
angles like that pse
regards
B
|