AV 257 then JA 5166 at Bogotá
Cancún → Bogota → Cartagena
Timetable, Bogota time
16:05AV 257 from Cancún at the gate
15:05JA 5166 to Cartagena leaves the gate
23 h apart on the timetable, overnight
JA 5166 leaves 23 h after AV 257 arrives on the timetable: more than half a day, so not a connection we count.