Your appointment import has an hour column and a minute column. Build a real time value from those parts so the schedule can sort by time.
Combine the fields with zero seconds
Enter 14 in B2 and 5 in C2. In D2 use =TIME(B2,C2,0). Format D2 as a 24-hour time and expect 14:05. Try 00:05 and 23:59 as checks at the edges of the day.

Illustrated TIME formula. Use a 24-hour number format.
Catch an input before it rolls into another hour
Check for whole hours from 0 to 23 and minutes from 0 to 59. If the minute is 65, TIME can display 15:05 for that input. Flag it in the source rather than accepting the plausible result. Keep a numeric zero minute for on-the-hour appointments.

Illustrated validation check. Inspect the parts as well as the display.



