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