[R] Weird Excel Time Format

Prof Brian Ripley ripley at stats.ox.ac.uk
Tue Nov 29 18:32:51 CET 2011

If all else fails, read the help page.  There are examples on 
?as.Date of reading Excel dates.

But I don't believe the time you give. (0.577662037 is just before 

On Tue, 29 Nov 2011, Hasan Diwan wrote:

> I have a 10-column XLS file, with 2 date fields. As far as I can tell,
> they were configured identically in Excel 2010. One of these fields
> resembles "39406.577662037", whilst in Excel, it is shown as
> "2007-11-20 13:42:20". Applying as.Date() with the default format
> doesn't do it. Any ideas as to what format this is? Many thanks! -- H

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

More information about the R-help mailing list