Hours by Person

Question

Hello I can get to import my time column as a time format or date_time format It returns NA, how can i go about this, first_form should be time format and look like last_form(which is currently character) on the preview ? enter image description here

Inmigrations <- read_excel("Inmigrations.xlsx", 
    col_types = c("skip", "skip", "skip", 
        "skip", "text", "date", "text", "text", 
        "numeric", "text", "numeric", "date"))

Answer 1

Try lubridate after importing it as character type:

library(lubridate)

df$first_form <- hms(df$first_form)