Degree ,Min, Sec

  • Thread starter Degree ,Min, Sec
  • Start date
D

Degree ,Min, Sec

What does it mean : 1/1/1900 6:00:00 AM, it has been used to get Degree
,Min, Sec , in the sheet
 
I

Ian

The cell is formatted to show the data as date/time. Excel stores these as
numbers starting at 1 Jan 1900. Your data appears to be 0.25 ie quarter of a
day, shown as 6AM on 1 Jan 1900.

What are you actually trying to achieve?
 
D

David McRitchie

Hi Degree Min Sec (and Ian),
It is a matter of formatting.
days (d), hours (h), minutes(m), seconds (s)
degrees (h), minutes (m), seconds(s)

You probably want to format your cell as [h]° mm' ss\"
the degree symbol is ALT+0176 on the numeric keypad.

More information and links in
: http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm#msexcel
also see Chip Pearson's "Latitude and Longitude"
http://www.cpearson.com/excel/latlong.htm

You would get a lot more out of newsgroups if you used your actual full name,
and a working email address. You can get a email address strictly for
newsgroups. You would also get a lot more out of newsgroups if
you first did a Google Groups search, and a Google web search.
http://www.mvps.org/dmcritchie/excel/xlnews.htm
 
Top