View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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