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.

Hour 14 and minute 5 become 14:05 in the output.

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.

Minute 65 rolls over into the next hour, so the input needs review.

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

Microsoft’s TIME function reference