RExcel (the addin package for RExcel I wrote)
tries very hard to transfer dates and times
from Excel to R.
David Scott wrote:
>
> I have used xlsReadWrite to read data from an Excel spreadsheet.
>
> I had a problem with converting times of the day so that I could create
> POSIXct date-time obj
> Excel stores times of the day as fractions of a day so I wrote a function to
> convert the fraction to a number of seconds, extract the hours, minutes and
> seconds and output it in ISO standard format (%H:%M:%S).
What about the 'colClasses' or 'dateTimeAs' argument in 'read.xls'
which gives bac
The chron package stores times as a fraction of the day. See R News 4/1.
On Sun, Feb 22, 2009 at 8:26 PM, David Scott wrote:
>
> I have used xlsReadWrite to read data from an Excel spreadsheet.
>
> I had a problem with converting times of the day so that I could create
> POSIXct date-time objects
I have used xlsReadWrite to read data from an Excel spreadsheet.
I had a problem with converting times of the day so that I could create
POSIXct date-time objects. I was wondering if there was a better
solution.
Excel stores times of the day as fractions of a day so I wrote a function
to co
4 matches
Mail list logo