degrees minutes seconds

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top