search for: posixctdatetim

Displaying 1 result from an estimated 1 matches for "posixctdatetim".

Did you mean: posixctdatetime
2009 Feb 23
3
Dates and times from Excel
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 convert the fraction to a number of seconds, extract the hours, minutes and seconds and output it in ISO