Re: [R] Help with Converting Excel Times to R

2021-07-26 Thread PIKAL Petr
hawn Way > Sent: Wednesday, July 21, 2021 9:23 PM > To: r-help@r-project.org > Subject: [R] Help with Converting Excel Times to R > > I've usually had good luck with this, but something is not working well. I have > two datetimes in excel > > 7/20/21 13:30 > 7/20/2

Re: [R] Help with Converting Excel Times to R

2021-07-21 Thread Shawn Way
Original Message- From: Jim Lemon Sent: Wednesday, July 21, 2021 6:09 PM To: Shawn Way Cc: r-help@r-project.org Subject: Re: [R] Help with Converting Excel Times to R Hi Shawn, I don't have any trouble with this: times<-c("7/20/21 13:30","7/20/21 13:40") strpt

Re: [R] Help with Converting Excel Times to R

2021-07-21 Thread Andrew Simmons
Hello, >From playing around with your numbers, it seems like you are using Excel 1904 Date System, which isn't a problem, it just means that your numbers are days from 1904-01-01 instead of 1900-01-01. The following is my solution: times <- c(42935.5625,42935.569444) as.POSIXlt(( # off

Re: [R] Help with Converting Excel Times to R

2021-07-21 Thread Jim Lemon
Hi Shawn, I don't have any trouble with this: times<-c("7/20/21 13:30","7/20/21 13:40") strptime(times,"%m/%d/%y %H:%M",tz="GMT") [1] "2021-07-20 13:30:00 GMT" "2021-07-20 13:40:00 GMT" I suspect that Excel is causing the problem. Try changing the format of the date column to "Text" and work on t

[R] Help with Converting Excel Times to R

2021-07-21 Thread Shawn Way
I've usually had good luck with this, but something is not working well. I have two datetimes in excel 7/20/21 13:30 7/20/21 13:40 And when I convert these to excel's normal storage schema, I get the following: 42935.5625 42935.56944 Just try to convert this to a POSIX class gives me issues.