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

BruceM

Access does not have cells. If this is an Access question, the Mod operator
should let you accomplish what you want. To place the result in a text box
set the Control Source to:

=([Value1] + [Value2]) Mod 360

You can use a similar expression in a query or in VBA. The specifics depend
on how exactly you are trying to do this. If you need clarification, post
details.
 
Top