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