[R] Weird Excel Time Format

[Hasan Diwan]

On 29 November 2011 10:26, Jeff Newmiller <jdnewmil at dcn.davis.ca.us> wrote:
> You haven't indicated how you are accessing the Excel file, or whether it is an XLS or XLSX file. It sounds like you might be using rcom or a dependent package, in which case you may need to read the Excel COM interface documentation more carefully. In any event, you can't expect as.Date to understand the floating-point numbers as if they were formatted dates it they aren't.

I'm using the xlsx package to access this file. It is an XLS file. I
think I got it sorted though. The column that has the problem has
NA's, whereas the column that does not is complete.

> For my part, I highly recommend exporting to CSV before importing to R.

Will look into doing so...
-- 
Sent from my mobile device
Envoyait de mon portable