Organize Date and Hours in RStudio

Asked Jul 14 '20 at 21:46

Active Jul 14 '20 at 22:36

Viewed 65 times

I have a dataset with different entries for hours. Example 23:59 and 11:59PM. I have tried using the command below but did not work. It is changing only the time that appears PM and AM and making NA in other rows

t <- "1:36:22 PM" as.POSIXlt(t, format = "%H:%M:%S")

edited Jul 14 '20 at 22:36

asked Jul 14 '20 at 21:46

Glaucia Andriani

You can use `as.POSIXct("11:59 PM", format = "%I:%M %p")` – akrun Jul 14 '20 at 22:16
I tried but is changing only the rows with this format and making other rows as "NA" – Glaucia Andriani Jul 15 '20 at 13:29

Organize Date and Hours in RStudio

0 Answers0