Offset
The time difference between Barcelona and Bogotá is 7 hours.
Barcelona (CEST) is ahead of Bogotá (COT).
CEST: UTC+2
COT: UTC-5
Barcelona is currently observing daylight saving time; Bogotá is not.
When to schedule
Business-hours overlap: 4 PM–5 PM in Barcelona (9 AM–10 AM in Bogotá).
Both teams are in working hours during this window on weekdays.
Suggested time: 4:00 PM Barcelona (9:00 AM Bogotá).
This window may shift by an hour during daylight saving time.
Public holidays in 2026
National public holidays can affect availability — a counterpart is likely off work on their own holidays, so it's worth planning meetings and deadlines around them.
Spain
- New Year's DayThu, Jan 1
- EpiphanyTue, Jan 6
- Good FridayFri, Apr 3
- Labour DayFri, May 1
- AssumptionSat, Aug 15
- National Day of SpainMon, Oct 12
- All Saints DaySun, Nov 1
- Constitution DaySun, Dec 6
- Immaculate ConceptionTue, Dec 8
- Christmas DayFri, Dec 25
Colombia
- New Year's DayThu, Jan 1
- EpiphanyMon, Jan 12
- Saint Joseph's DayMon, Mar 23
- Maundy ThursdayThu, Apr 2
- Good FridayFri, Apr 3
- Labour DayFri, May 1
- Ascension DayMon, May 18
- Corpus ChristiMon, Jun 8
- Sacred HeartMon, Jun 15
- Saint Peter and Saint PaulMon, Jun 29
- Declaration of IndependenceMon, Jul 20
- Battle of BoyacáFri, Aug 7
- Assumption of MaryMon, Aug 17
- Columbus DayMon, Oct 12
- All Saints’ DayMon, Nov 2
- Independence of CartagenaMon, Nov 16
- Immaculate ConceptionTue, Dec 8
- Christmas DayFri, Dec 25
About these zones
Quick reference
Full 24-hour conversion table — tap any time to open it in the converter.
| Barcelona | Bogotá | Day |
|---|---|---|
| 12:00 am | 5:00 pm | -1 day |
| 1:00 am | 6:00 pm | -1 day |
| 2:00 am | 7:00 pm | -1 day |
| 3:00 am | 8:00 pm | -1 day |
| 4:00 am | 9:00 pm | -1 day |
| 5:00 am | 10:00 pm | -1 day |
| 6:00 am | 11:00 pm | -1 day |
| 7:00 am | 12:00 am | Same day |
| 8:00 am | 1:00 am | Same day |
| 9:00 am | 2:00 am | Same day |
| 10:00 am | 3:00 am | Same day |
| 11:00 am | 4:00 am | Same day |
| 12:00 pm | 5:00 am | Same day |
| 1:00 pm | 6:00 am | Same day |
| 2:00 pm | 7:00 am | Same day |
| 3:00 pm | 8:00 am | Same day |
| 4:00 pm | 9:00 am | Same day |
| 5:00 pm | 10:00 am | Same day |
| 6:00 pm | 11:00 am | Same day |
| 7:00 pm | 12:00 pm | Same day |
| 8:00 pm | 1:00 pm | Same day |
| 9:00 pm | 2:00 pm | Same day |
| 10:00 pm | 3:00 pm | Same day |
| 11:00 pm | 4:00 pm | Same day |
Daylight saving time
Barcelona observes daylight saving time; Bogotá does not. The offset between the two zones changes when Barcelona transitions: on Sunday, October 25, 2026, clocks fall back from CEST to CET.
See the daylight saving time page for transition dates across every time zone.
Daylight today
- Sunrise
- 6:19 AM
- Sunset
- 9:24 PM
- Day length
- 15h 5m
- Sunrise
- 5:45 AM
- Sunset
- 6:07 PM
- Day length
- 12h 23m
Cities in these zones
Other cities in Central European Time
Other cities in Colombia Time
Browse all cities to see the current local time anywhere.
Airports in these zones
Airports in Central European Time
- MAD
- BCN
Airports in Colombia Time
- BOG
- CLO
- EOH
- MDE
Related conversions
Common conversions
- What is 9:00 am Barcelona in Bogotá?
- 9:00 am Barcelona is 2:00 am Bogotá.
- What is 12:00 pm Barcelona in Bogotá?
- 12:00 pm Barcelona is 5:00 am Bogotá.
- What is 12:30 pm Barcelona in Bogotá?
- 12:30 pm Barcelona is 5:30 am Bogotá.
- What is 2:00 pm Barcelona in Bogotá?
- 2:00 pm Barcelona is 7:00 am Bogotá.
- What is 5:00 pm Barcelona in Bogotá?
- 5:00 pm Barcelona is 10:00 am Bogotá.
- What is 11:30 pm Barcelona in Bogotá?
- 11:30 pm Barcelona is 4:30 pm Bogotá.