Offset
The time difference between Madrid and Medellín is 7 hours.
Madrid (CEST) is ahead of Medellín (COT).
CEST: UTC+2
COT: UTC-5
Madrid is currently observing daylight saving time; Medellín is not.
When to schedule
Business-hours overlap: 4 PM–5 PM in Madrid (9 AM–10 AM in Medellín).
Both teams are in working hours during this window on weekdays.
Suggested time: 4:00 PM Madrid (9:00 AM Medellín).
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.
| Madrid | Medellín | 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
Madrid observes daylight saving time; Medellín does not. The offset between the two zones changes when Madrid 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:46 AM
- Sunset
- 9:44 PM
- Day length
- 14h 58m
- Sunrise
- 5:48 AM
- Sunset
- 6:16 PM
- Day length
- 12h 28m
Cities in these zones
Other cities in Central European 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 Madrid in Medellín?
- 9:00 am Madrid is 2:00 am Medellín.
- What is 12:00 pm Madrid in Medellín?
- 12:00 pm Madrid is 5:00 am Medellín.
- What is 12:30 pm Madrid in Medellín?
- 12:30 pm Madrid is 5:30 am Medellín.
- What is 2:00 pm Madrid in Medellín?
- 2:00 pm Madrid is 7:00 am Medellín.
- What is 5:00 pm Madrid in Medellín?
- 5:00 pm Madrid is 10:00 am Medellín.
- What is 11:30 pm Madrid in Medellín?
- 11:30 pm Madrid is 4:30 pm Medellín.