How do I formate a cell or column of cells to handle full angular
measurements. eg 359degrees 59' 59.99" Similar to time except the 'hour'
would go up to 360 not 24.

Hi Terry:

This topic is very well covered in:

http://www.cpearson.com/excel/latlong.htm
--
Gary''s Student - gsnu200723

I found that I had to add the degrees seperate as I was using the TIME
function (otherwise the value is not interperated as time, but as a sting) to
create a number (time) from a text string.

So I created the minutes and seconds and added the degrees/24. The help file
states that the degrees over 24 will be reduced by 24 until it is between 0
and 23.

This example I used was to create a useable value from a Lieca GSI file
created by a Total Station (surveying talk):

B7 21.324+0000000016828040
B8 168°28'04" from formula

=(LEFT(RIGHT(B7,8),3)/24)+TIME(0,LEFT(RIGHT(B7,5),2),LEFT(RIGHT(B7,3),2) )

Bit hard to follow, but do a cut and paste and it should work.

Paul the Surveyor

PS. Gary's stuff is good and gave me the right pointers.

"Gary''s Student" wrote:

Hi Terry:

This topic is very well covered in:

http://www.cpearson.com/excel/latlong.htm
--
Gary''s Student - gsnu200723