Not sorting correctly

I have a data set that I am trying to sort by time oldest to newest. The time is in column D of the example. It is not sorting correctly as the 24:00:00 times are not moving to the end of the day. I performed a find and replace with the times to turn 00:00:00 into 24:00:00 respectively. The numbers are displaying differently and I am not sure why and that may have something to do with it. How can I get this to numerically sort correctly?