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°

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°

"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

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?
--
David Biddulph

dougsan wrote:
"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

On Sun, 22 Feb 2009 02:01:01 -0800, dougsan
wrote:

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

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

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.


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

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

"dougsan" wrote in message
...

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.


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

Its all OK the light has gone on
Doug

"David Biddulph" wrote:

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

"dougsan" wrote in message
...

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.


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

Its ok Ron the light is now turnd on

"Ron Rosenfeld" wrote:

On Sun, 22 Feb 2009 02:01:01 -0800, dougsan
wrote:

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

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

On Thu, 26 Feb 2009 02:21:02 -0800, dougsan
wrote:

Its ok Ron the light is now turnd on

Good to hear!

"Onward through the fog" :-)
--ron