The OP wants to sort based on two columns (date and time). We cannot seem to communicate clearly.

Maybe I am missing something.

Too frustrated to continue here:
https://www.excelforum.com/excel-gen...en-time-2.html