rom: R-help On Behalf Of Eliza Botto
> Sent: Tuesday, August 31, 2021 10:26 PM
> To: r-help@r-project.org
> Subject: [R] Converting characters back to Date and Time
>
> DeaR useR,
>
> I read an excel column in R having Date and time (written in the same
cell) as
> follow,
>
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
Hello,
I'm assuming you're reading from an "*.xlsx" file. I'm not sure which
package you're using for this scenario, but my preference is 'openxlsx'. If
this is the package you're using, you could set argument 'detectDates' to
'TRUE', and then it should read them correctly.
FILE <- tempfile(fil
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 ve
4 matches
Mail list logo
