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

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

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?