Signs with Degrees

[Sakurkar]

Dear friends,
I am preparing some excel sheets,
in one column I have list of degrees in decimal i.e. 165.304, 3.254 etc.
One sign consist of 30 degrees. I want this converted in to Signs and degrees.
165.304 = 5 Signs and 15.304 is the answer or 3.254 = 0 Signs and 3.254
Is there any formula for above calculations ? It will save my lots of time.
Please help me.
Thanks.
Sakurkar

 

[Marcelo Branco]

Maybe

Signs
=INT(A2/30)

Degrees
=MOD(A2,30)

Hope this helps

M.

 

[Sakurkar]

Dear Marcelo Branco,
Thanks for your quick reply, these formulas are working nicely.
This will save my valuable time.
once again I thank you.
Sakurkar, India.

 

[Marcelo Branco]

You are welcome. Glad to help.

M.