Excel question help please

  starlet 00:14 27 Jan 05
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 05

If you can calculate an answer in Radians then click here

  stlucia 12:42 27 Jan 05

... 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 05

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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…