[R] Excel date to R format

Gabor Grothendieck ggrothendieck at gmail.com
Mon Apr 12 22:49:34 CEST 2010


See the relevant article in R News 4/1.

On Mon, Apr 12, 2010 at 10:36 AM, ManInMoon <xmoon2000 at googlemail.com> wrote:
>
> I have searched and tried to read before posting but can find nothing to
> accomplish change Excel dates in double format to R
>
> Can someone please help
>
> I have a vector of double like this from Excel.
>
> 39965.0004549653
>
> and I want to put them in R such that I can display them in any Date and
> Time format.
>
> as.Date does it ALMOST but chops off the fractional seconds. POSIXct doesn't
> appear to do what I need.
> --
> View this message in context: http://n4.nabble.com/Excel-date-to-R-format-tp1837208p1837208.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



More information about the R-help mailing list