AV 7 then AV 8580 at Bogotá
Miami → Bogota → Valledupar
Timetable, Bogota time
19:45AV 7 from Miami at the gate
18:50AV 8580 to Valledupar leaves the gate
23 h 05 apart on the timetable, overnight
AV 8580 leaves 23 h 05 after AV 7 arrives on the timetable: more than half a day, so not a connection we count.