[R] Problems plotting date and time column from excel using R

2010-05-11 Thread Terry Bassett
I am using R to read from an excel(csv) file. Within the excel file is a column with the date set that looks likes this: 53:40.2 and in the Insert function box it looks likes this: 9/21/2006  4:53:40 PM I tired separating the time and date using the function below and then plotting again

Re: [R] Problems plotting date and time column from excel using R

2010-05-11 Thread David Winsemius
On May 11, 2010, at 9:00 AM, Terry Bassett wrote: I am using R to read from an excel(csv) file. Within the excel file is a column with the date set that looks likes this: 53:40.2 and in the Insert function box it looks likes this: 9/21/2006 4:53:40 PM This is really an Excel question,

Re: [R] Problems plotting date and time column from excel using R

2010-05-11 Thread David Scott
David Winsemius wrote: On May 11, 2010, at 9:00 AM, Terry Bassett wrote: I am using R to read from an excel(csv) file. Within the excel file is a column with the date set that looks likes this: 53:40.2 and in the Insert function box it looks likes this: 9/21/2006 4:53:40 PM This is

Re: [R] Problems plotting date and time column from excel using R

2010-05-11 Thread RICHARD M. HEIBERGER
I recommend that you use RExcel to get your files directly from the xls or xlsx file into R. RExcel correctly transfers dates from Excel to R. rcom.univie.ac.at for full information. You can begin with the RExcelInstaller package from CRAN. Rich [[alternative HTML version deleted]]

Re: [R] Problems plotting date and time column from excel using R

2010-05-11 Thread Gabor Grothendieck
Check out the options listed here: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows On Tue, May 11, 2010 at 9:00 AM, Terry Bassett tntbass...@yahoo.com wrote: I am using R to read from an excel(csv) file. Within the excel file is a column with the date set that looks likes this: