LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
RAY
 
Posts: n/a
Default How do I use degrees, minutes and seconds in excel.

I am trying to add and subtract degrees, minutesand seconds using excel anfd
I have been unable to find the properway to enter the number. For example,
45deg 30min 20sec, how would I enter this in a cell so that I can set up a
worksheet to add or subtract cells with angular information?

Thank you
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert decimal degrees to degrees minutes seconds Chris r Excel Discussion (Misc queries) 2 December 6th 05 10:40 PM
how do I add minutes and seconds together in excel BeirutBomber Excel Worksheet Functions 1 August 21st 05 11:10 AM
Convert seconds to minutes and seconds in excel anonymous Excel Worksheet Functions 3 December 25th 04 08:38 PM
How do I get a cell to display degrees, minutes, seconds? Bill Excel Worksheet Functions 2 December 22nd 04 12:13 PM
converting from digital degrees to degrees minutes seconds Patricio Boric Excel Worksheet Functions 1 November 28th 04 07:43 PM


All times are GMT +1. The time now is 01:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"