Thread: how to add degree,minutes and seconds
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bal Bal is offline
external usenet poster
  
Posts: 1
Default how to add degree,minutes and seconds
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
Reply With QuoteReply With Quote