format cells in degrees & minutes of arc

  • Thread starter Thread starter dougsan
  • Start date Start date
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°
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

format cells in degrees & minutes of arc. 8
How to determine the arc length in Excel? 5
Fractal Design Arc Midi R2 Case 0
compring two data sets 3
degrees decimal minutes format for latitude longitude 2
Decimal numbers in Excel 14
How do i draw a closed arc in powerpoint? 1
Formatting cells as degrees? 1

Back
Top