format cells in degrees & minutes of arc.
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°
|