format cells in degrees & minutes of arc.
"Jarek Kujawa" wrote:
try:
=MOD(A1,360)
HIH
On 20 Lut, 11:58, dougsan wrote:
I am back!!!!!
What i am trying to do is format cells in degrees & minutes of arc. i have
tried useing the time function but the problem i run into is
if i have 270° and i need to add 100° in a clockwise direction i get 370°
not 10°
HI i think this is on the right track. but lets go one stage futher.
if the sum of the numbers are more than 360 then take 360 off but if the sum
is less than 360 leave it stand
|