I am reading in data from a .xlsx file. One of my columns is the current time which is formatted hour:mins and the other column is the data which is formatted dd/mm/yyyy.
I would like to be able to truncate the time column so I only get the hour, then do the same for minutes (obviously I will have to copy the column vector before hand). The same goes for the date column that uses a / delimiter.
What is the best solution for this?