sort data based on date and time priority

Hi everyone,

I am creating a simple leave tracker excel file. I am having difficulty in getting the priority slot when comparing date and time. I tried using Max function but it does not give me the results I need. Attached is a sample file.

Thanks,

stoey