Are there any built in formula's that can convert decimal angles to hours,
minutes,seconds format?

Have a look at Chip Pearson's site for working with angles expressed as degrees,
minutes, seconds.



Gord Dibben MS Excel MVP



On Sat, 5 Aug 2006 23:36:01 -0700, fishy
wrote:

Are there any built in formula's that can convert decimal angles to hours,
minutes,seconds format?

And the link to that web page is ...

http://www.cpearson.com/excel/latlong.htm

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Have a look at Chip Pearson's site for working with angles expressed as
degrees,
minutes, seconds.



Gord Dibben MS Excel MVP



On Sat, 5 Aug 2006 23:36:01 -0700, fishy
wrote:

Are there any built in formula's that can convert decimal angles to
hours,
minutes,seconds format?

Now that's a very handy tip<g

Thanks RD

FOF

On Sun, 6 Aug 2006 10:03:50 -0700, "Ragdyer" wrote:

And the link to that web page is ...

http://www.cpearson.com/excel/latlong.htm

Gord Dibben MS Excel MVP

Those F's in FOF are scaring me Gord!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Now that's a very handy tip<g

Thanks RD

FOF

On Sun, 6 Aug 2006 10:03:50 -0700, "Ragdyer"
wrote:

And the link to that web page is ...

http://www.cpearson.com/excel/latlong.htm

Gord Dibben MS Excel MVP

If you missed yesterday's exchange with Dave P.

FOF...........forgetful old fart


Gord

On Sun, 6 Aug 2006 10:18:21 -0700, "Ragdyer" wrote:

Those F's in FOF are scaring me Gord!<bg

Or maybe he just forgot it!

<GD&R

Gord Dibben wrote:

If you missed yesterday's exchange with Dave P.

FOF...........forgetful old fart

Gord

On Sun, 6 Aug 2006 10:18:21 -0700, "Ragdyer" wrote:

Those F's in FOF are scaring me Gord!<bg

--

Dave Peterson

Damn ... I posted a response here yesterday, and now it's nowhere to be
found!

Not even in Google.

But my O.E. shows that an answer was posted to your message.

Must have something to do with one of my machines.

Frustrating ! ! !

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
Or maybe he just forgot it!

<GD&R

Gord Dibben wrote:

If you missed yesterday's exchange with Dave P.

FOF...........forgetful old fart

Gord

On Sun, 6 Aug 2006 10:18:21 -0700, "Ragdyer"
wrote:

Those F's in FOF are scaring me Gord!<bg

--

Dave Peterson