[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