View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian
 
Posts: n/a
Default Degree ,Min, Sec

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?

--
Ian
--
"Degree ,Min, Sec" <Degree ,Min, wrote in
message ...
What does it mean : 1/1/1900 6:00:00 AM, it has been used to get Degree
,Min, Sec , in the sheet