Cant get Time Format

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
?

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

if its in a nonstandard time format then load it as character, and transform it to a time representation in a further step.
probably the hms library will be useful.
Once you have read the data with the time columns as character, read through this reprex guide, on how to share a sample of the data if you require further help.
reprex

1 Like

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.