[R] Help with Converting Excel Times to R

Shawn Way @w@y @end|ng |rom empowerph@rm@cy@com
Wed Jul 21 21:23:28 CEST 2021

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:


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

More information about the R-help mailing list