[R] Weird Excel Time Format

Hasan Diwan hasan.diwan at gmail.com
Tue Nov 29 17:59:11 CET 2011

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

Sent from my mobile device
Envoyait de mon portable

More information about the R-help mailing list