Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I enter degrees, minutes, seconds
I have an excal project that requires me to use degrees, minutes and seconds.
How do I enter this into a cell |
#2
|
|||
|
|||
For the degrees go to insert menu and select symbol; make sure your font says
symbol and locate the degree symbol, press enter. For the time, go to format menu and select cells, press the number tab and select time and find the format you want to use. "Edwn" wrote: I have an excal project that requires me to use degrees, minutes and seconds. How do I enter this into a cell |
#3
|
|||
|
|||
Hi Edwn
for a good explaination on the topic check out http://www.cpearson.com/excel/latlong.htm Cheers JulieD "Edwn" wrote in message ... I have an excal project that requires me to use degrees, minutes and seconds. How do I enter this into a cell |
#4
|
|||
|
|||
Hi!
When you have formatted a cell as [h]:mm:ss, enter your data as, for example, 12:48:06. You will then find you can calculate using the contents of the cell (addind, multiplying etc). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter minutes and seconds (lap times)? | Excel Discussion (Misc queries) | |||
How do I get a cell to display degrees, minutes, seconds? | Excel Worksheet Functions | |||
convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Minutes and Seconds | Excel Worksheet Functions | |||
converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions |