Skip to content
Prev 278798 / 398502 Next
Original Raw

Weird Excel Time Format

Hasan Diwan 
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

Thread (7 messages)

Hasan Diwan Weird Excel Time Format Nov 29 Brian Ripley Weird Excel Time Format Nov 29 Hasan Diwan Weird Excel Time Format Nov 29 Jeff Newmiller Weird Excel Time Format Nov 29 Hasan Diwan Weird Excel Time Format Nov 29 Kevin E. Thorpe Weird Excel Time Format Nov 29 Nordlund, Dan (DSHS/RDA) Weird Excel Time Format Nov 29