Bearings and angles in Excel

Hi there

Can anyone tell me if it is possible to use angles and bearings in the degrees minutes and seconds format (eg 180˚38'10"), and actually get Excel to be able to perform calculations on them?

Ben

I will share this two formats that would help you:

1. Given is 86 degrees, 35 minutes and 49 seconds. Make six columns which represents, for example, Cell A1 enter degree number 86, Cell B1 for symbol of degrees click instert and click symbol to find the degree sign or press and hold ALT 0176, Cell C1 enter the minute number 35, Cell D1 enter the minute sign " ' ", Cell E1 enter second 49, and last Cell F1 enter the second sign " " ". So now, we will create like the format that you've expected: At Cell H1, here is the formula: enter =CONCATENATE(A1,B1,C1,D1,E1,F1), then it will apear like this: 86°35'49"

2. If you have an Azimuth of 124.38 degrees and convert it to DMS, here, at cell A1, enter that degree: 124.38, just follow this: At Cell C1, enter the formula =TRUNC(A1), next at Cell D1, enter this =TRUNC((A1-(C1))*60), and at Cell E1 =(A1-(C1)-(D1/60))*3600, then it will appear 124°22'53.45"