ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   surveying formula (https://www.excelbanter.com/excel-worksheet-functions/103399-surveying-formula.html)

fishy

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

Gord Dibben

surveying formula
 
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?



RagDyeR

surveying formula
 
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?




Gord Dibben

surveying formula
 
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

RagDyeR

surveying formula
 
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



Gord Dibben

surveying formula
 
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

surveying formula
 
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

RagDyeR

surveying formula
 
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




All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com