How do I enter degrees, minutes, seconds

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

Guest

I have an excal project that requires me to use degrees, minutes and seconds.
How do I enter this into a cell
 
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.
 
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).
 

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

Very high CPU temperature, how can i fix it? 1
degrees decimal minutes format for latitude longitude 2
Want to display degrees, minutes, seconds. (0°00'00") 1
how do i enter angles in exel? 5
How do you convert decimal degrees to degrees minutes seconds 2
convert decimal degrees to degrees minutes seconds 2
How do I show Latitude and Longitude in Excel Table 1
Decimal numbers in Excel 14

Back
Top