format cells in degrees & minutes of arc.

D

dougsan

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°
 
D

dougsan

Jarek Kujawa said:
try:

=MOD(A1,360)

HIH
Click to expand...

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
 
D

David Biddulph

Have you looked at what MOD does? [If not, please take the trouble to look
it up in Excel help, and/or just try it.]
In what way does it not do what you want?
 
R

Ron Rosenfeld

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
Click to expand...

And exactly what problem did you run into when you tried the suggestion.

Please post your input, actual output using the suggestion, and what you
expected.
--ron
 
D

dougsan

What i am trying to do is set up a spred sheet that would allow me to apply
magnetic varation to a true course. the varation coud be east or west in
which case i would eather + or - the ajustment. for example if true course
was 005° Mag VAR 12°W i would have to -12° to give me a mag heading of 364°
and if True course 356° Var 12°E i would need to +12° mag heading 008°
I hope that gives you a clearer understanding of what i am trying to do.
 
D

David Biddulph

I don't know how you get your 364 instead of 353, but if you are still
asking how to deal with wrapping round at 360, you were given the answer of
using the MOD function.
 
D

dougsan

Its all OK the light has gone on
Doug

David Biddulph said:
I don't know how you get your 364 instead of 353, but if you are still
asking how to deal with wrapping round at 360, you were given the answer of
using the MOD function.
Click to expand...
 
D

dougsan

Its ok Ron the light is now turnd on

Ron Rosenfeld said:
And exactly what problem did you run into when you tried the suggestion.

Please post your input, actual output using the suggestion, and what you
expected.
--ron
Click to expand...
 
Top