Re: [R] Serial Date

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Tue, 15 Mar 2011 10:24:19 -0400

On Sun, Mar 13, 2011 at 10:00 PM, Raoni Rosa Rodrigues <raonirosa_at_yahoo.com.br> wrote:
> Hello R Help,
>
> I'm working in a project with a software that register date and time data in serial time format. This format is used by excel, for exemple. In this format, 40597.3911423958 is 2011/2/23 09:23:15. First part is number os days since 1900/1/1, and second part is a fraction of a day.
>

Try this:

> library(chron)
> chron(40597.3911423958)


[1] (02/24/81 09:23:15)

See R News 4/1 and the references there.

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.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.
Received on Tue 15 Mar 2011 - 14:33:26 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 16 Mar 2011 - 04:00:22 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive