I need to import a column from Excel that contains times in two different formats per screenshot below.
How can I make all times conform to the 24-hour format?
I will need to sort records based on this field. Since all time in Pan X is recorded in numbers, I have made the Time field an integer.
I have read other posts on Date type but I couldn’t find anything on Time.