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