I have this type of format in EXCEL Date and Time
:
but when I open it in Rstudio those number become "43972.977083333331", please help me. How can i convert those numbers into a DATE AND TIME format?....
Thanks
I have this type of format in EXCEL Date and Time
:
but when I open it in Rstudio those number become "43972.977083333331", please help me. How can i convert those numbers into a DATE AND TIME format?....
Thanks
It looks like those are numeric representations in days since Jan 1, 1900 so try something like this
my_time <- as.Date.numeric(43972.977083333331, origin = '1900-01-01')
The help file for as.Date.numeric has a lot more information
?as.Date.numeric
Hi Phil, it worked, like this:
as.Date.numeric(43972.977083333331, origin = '1900-01-01')
[1] "2020-05-23
but I need the "Time" too, How can i do this?, like this:
[1] "2020-05-23 20:00
¿How can I do this?
Sorry I missed this on first read
R provides several options for dealing with date and date/time data. The builtin as.Date function handles dates (without times); the contributed library chron handles dates and times, but does not control for time zones; and the POSIXct and POSIXlt classes allow for dates and times with control for time zones.
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.