Convert Decimal Degree to Degrees, Minutes, Second

[chuckcou]

Oh, please tell me there is a way to do this. I need to convert decimal degrees to Degrees, Minutes, Seconds.

If I have a number 34.54846 I need a calculation that outputs

343254.5 with is 34deg 32' 54.5".

I am not sure how to really do this, but it looks like the formula would be-

Line A-Take the 34 from before the decimal

Line B-Take the .54846 * 60 = 32.9076

Line C-Take the .9076{from the above line} * 60=54.456

Now take 34 from Line A

take the 32 which is before the decimal from Line B

and last take the 54.456 and round to 1 decimal fro Line C

Combine A,B,C and you get 343254.5

I think this is how it would be done

Thanks for the help and your time

[RalphL]

You have the method. Do you need help to implement it?