ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to add degree,minutes and seconds (https://www.excelbanter.com/excel-discussion-misc-queries/158766-how-add-degree-minutes-seconds.html)

Bal

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

Jim Thomlinson

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



All times are GMT +1. The time now is 12:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com