Madrid is 7 hours ahead of Bogotá
Best overlap: 8:00 AM to 11:00 AM in Bogotá is 3:00 PM to 6:00 PM in Madrid.
Target 8:00 AM to 11:00 AM in Bogotá, which lands at 3:00 PM to 6:00 PM for the Madrid side. Madrid is 7 hours ahead of Bogotá, so the practical overlap is about 3 hours — generous enough for meetings, tight enough to be worth booking ahead. Don't be caught out by clock changes — Madrid observes daylight saving and Bogotá doesn't, so the offset varies by an hour through the year.