Excel question help please

  starlet 00:14 27 Jan 2005
Locked

How to write a formula to show divisions of 360 degrees as: degrees-minutes-seconds in excel I cannot find anyway to format the answer.
Example in excel 360 divided by 84 =4.285714degrees, to find out the position of the 58 tooth in a wheel, multiply 58 by 4.285714 the output I am getting is 248.57, the same as the calculator but the true answer is 248 degrees 34 minutes.
Can anyone explain to me where I am going wrong please.

Regards Starlet

  VoG II 00:23 27 Jan 2005

If you can calculate an answer in Radians then click here

  stlucia 12:42 27 Jan 2005

... or you can set up another cell or column to determine the decimal part of the number (if your decimal answer is in A:1, put "=(a1-int(a1))*60" into B:1 without the quote marks. This subtracts the integer of your degrees (4) from the original number (4.285714) to give the fraction only (0.285714) and then multiplies it by 60 to give the minutes. You can also apply it to the minutes, if you want, to give you the seconds.

  starlet 16:12 28 Jan 2005

stlucia,
Thank you for explaining it clearly it's easy when you know how, I am new to excel and just trying to get my head round it.

Regards Starlet

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone