On Tue, 31 Aug 2021, Eliza Botto writes:
> DeaR useR,
>
> I read an excel column in R having Date and time (written in the same cell)
> as follow,
>
> 06/18/18 10:00
>
> 06/18/18 11:00
>
> 06/18/18 12:00
>
> In R environment, they are read as
>
> 43269.42
>
> 43269.46
>
> 43269.50
>
> Is there a way to covert these characters back to the original format?
>
> Thank-you very much in advance.
>
>
> Eliza Botto
>
If using a package is an option:
library("datetimeutils")
convert_date(c(43269.42, 43269.46, 43269.50), "excel")
## [1] "2018-06-18" "2018-06-18" "2018-06-18"
convert_date(c(43269.42, 43269.46, 43269.50), "excel", fraction = TRUE)
## [1] "2018-06-18 10:04:48 CEST" "2018-06-18 11:02:24 CEST"
## [3] "2018-06-18 12:00:00 CEST"
Note that the times differ: the numbers are probably
not /displayed/ to full precision in R.
You may also want to search the archives of this list,
as this question has been discussed before.
--
Enrico Schumann (maintainer of package datetimeutils)
Lucerne, Switzerland
http://enricoschumann.net
______________________________________________
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.
