Sexagesimal math

[Scott S.]

Hello all,

I am trying to work with a spreadsheet that computes corrections to measured angles.
Some of my formulas return results in seconds of arc that are greater than 60.
Since 60 seconds (or 60 minutes ) equals a "roll over" in the count of whole numbers I am having some issues.

Is there a means by which, for example 180 seconds of arc could be converted 3 minutes of arc.

I have attached the "offending" sheet and highlighted some results in blue that illustrate my problem.

Thanks for all the past help and anything you can do to point me in the right direction this time,
Scott

[Ace_XL]

to get you started..

=INT(A1/60)&"."&MOD(A1,60) will split the seconds into minutes and seconds separated by a decimal point

Is this somethin you can work with?

[Scott S.]

That is pretty neat and yes I can use that for some of the outputs.
I really like that format.

I should have phrased my problem in a clearer manner.
Matter of fact, I seem to have completely missed my own point.

I need to convert, say, 192.7 arc seconds into decimal degrees.

Thanks again.

[MarvinP]

Does 360 degrees equal to Pi time 2 times the radius? So 2Pi radians = 360 degrees?

[vlady]

Arc Second:

A unit of angular measure equal to 1/60 of an arc minute, or 1/3600 of a degree.

http://mathworld.wolfram.com/ArcSecond.html

[vandan_tanna]

=degrees(192.7/(60*60))

/(60*60) to convert arc sec to radians

[vlady]

or shorter a my given defenition.

=DEGREES(192.7*(1/3600))

[MarvinP]

Doesn't all this come from the circumference of a unit circle? Isn't it Pi times the diameter = circumference.

So you are needing 1/60th of that? Shouldn't there be a Pi somewhere in this calculation?

[Scott S.]

Thanks guys,
Several of you came up with solutions and I even got some hints on useful formats.
You guys are just the best.