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. > dt <- c(42935.5625,42935.5694444444) > as.POSIXct(dt,origin="1899-12-30 00:00:00",tz="GMT") [1] "1899-12-30 11:55:36 GMT" "1899-12-30 11:55:36 GMT" As you can see, there is a world of difference here. I've tried any number of solutions such as lubridate, etc and I get the same result > as_datetime(dt,origin="1899-12-30 00:00:00") [1] "1899-12-30 11:55:36 UTC" "1899-12-30 11:55:36 UTC" Any ideas about what I'm doing wrong? Shawn Way ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
