Please help asap!!!!!

**kckid12** · 03-29-2009, 11:33 PM

I am currently working on a spreadsheet for my college surveying class and I am stuck in a serious bind...

We measured 6 hubs using a bearing system (DMS) and now we have to get the cosine and sine of each bearing.

Example

87 degrees 12 minutes 48 seconds is the first measurement.....The distance is 150

the formula to get sine and cosine are Distance x Cos(Degree) but I don't know what formula I can use to get the DMS reading into degree?

My question is what formulas can I use to convert the DMS angle into a decimal?

87 degrees 12 minutes 48 seconds = 87.1233

if you punch 87.1233 into the calc and hit DD->DMS button it gives you the angle in DMS format...

**Mallycat** · 03-30-2009, 01:47 AM

Why don't you just do this.

Degrees + minutes/60 +seconds/360

**royUK** · 03-30-2009, 02:08 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**royUK** · 03-30-2009, 02:09 AM

Your thread is being closed for non compliance with our rules. Please PM me when you have read the forum rules RULES and made the changes to your post accordingly, i will then unlock your post so you may continue with the thread!

Post Closed

Please help asap!!!!!

LinkBack

Thread Tools

Display

Please help asap!!!!!

Re: Please help asap!!!!!

Re: Please help asap!!!!!

Re: Please help asap!!!!!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions