All values turning to NA while converting character to time type variable in R

Question

I tried to convert a column containing time details from characters to a time type variable. The code works but converts all the characters into NA. The values in the column before the code looks like '06:34:10'

The code I am running is similar to this:

df$time <- as.POSIXct(df$time, format = "%H-%M-%S")

I want it to be a time variable so I can conduct analyses by grouping the different times an event occurred.

did you look at : https://stackoverflow.com/questions/12034424/convert-character-to-time-in-r — Waldi, Jun 17 '20 at 21:18

score 0 · Answer 1 · answered Jun 17 '20 at 21:25

0

: instead to -

df$time <- as.POSIXct(df$time, format = "%H:%M:%S")

or

df$time <- strptime(df$time, format = "%H:%M:%S")

answered Jun 17 '20 at 21:25

Hamza Chennaq

66
4

All values turning to NA while converting character to time type variable in R

1 Answers1