sort data based on date and time priority

Here's a partial:

oldestDateTime = MIN(B6:B10,1)

Put that into any cell and it will give you the first entry. The "1" in "= MIN(B6:B10,1)" can be changed to any number to give you that rank -i.e. "2" will give you the second oldest.

Good luck with the rest.

Why no VBA, if you don't mind?