Barcelona 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 Barcelona.
Plan around 8:00 AM to 11:00 AM in Bogotá, which is 3:00 PM to 6:00 PM in Barcelona, to catch everyone during office hours. A 3-hour overlap gives you a workable daily window; aim for earlier in it to avoid clipping the end of someone's day. For part of the year the maths changes: Barcelona observes daylight saving, Bogotá does not, shifting the overlap by an hour.