degrees minutes and seconds

G

grandfilth

how can i make an angle in decimal show as an angle in degrees minut
and seconds
 
R

Ron Rosenfeld

how can i make an angle in decimal show as an angle in degrees minuts
and seconds?
Click to expand...

A1: Decimal Angle
B1: =A1/24
Format/Cells/Number/Custom Type:
[h]° mm' ss\"

(The "degree" sign is entered by holding down the <alt> key and typing 0176 on
the numeric keypad).

This takes advantage of the fact that there is the same relationship between
degrees/minutes/seconds as there is between hours/minutes/seconds and uses
Excel's built in time format.


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want to display degrees, minutes, seconds. (0°00'00") 1
Degrees, Minutes and Seconds 2
Excel Compass angles in Excel 10
Converting the sine of an angle to degrees, minutes, and seconds 6
How do you convert decimal degrees to degrees minutes seconds 2
degrees decimal minutes format for latitude longitude 2
Imputting an angle degree. Degree, minute, second 6
How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal 2

Top