Quick answer. Madrid is seven hours ahead of Bogotá before 25 October 2026. After Spain’s clock rollback, the difference is six hours.
Current time in Madrid and Bogotá
Madrid
Enable JavaScript to show the current time.
Bogotá
Calculated from your device clock and browser time-zone data. This is not an independent clock-synchronisation service. For a future appointment, use its actual date.
Convert a specific appointment → · Download the 72-row hourly table (CSV)
Plan an appointment between these cities
Open the tools with Madrid and Bogotá already selected. Review the example date and availability before choosing a start.
Find a shared meeting time · Check four weekly sessions across the clock change
Before and after 25 October
| Date in 2026 | Madrid | Bogotá | Difference |
|---|---|---|---|
| 24 October 2026 | 18:00 | 11:00 | Madrid +7 h |
| 26 October 2026 | 18:00 | 12:00 | Madrid +6 h |
| 2 November 2026 | 18:00 | 12:00 | Madrid +6 h |
Convert your own appointment
Find the same instant
By date · 2026The independent event lasts 60 minutes. Review the date, time and duration before importing.
Your Colombian participant can keep the clock and still see a new meeting time
This page represents Bogotá using America/Bogota. Europe’s October adjustment changes the difference even when the participant in Colombia does not change their clock. A dated conversion is more useful than memorising one subtraction for the whole year.
A Friday meeting at 17:00 in Madrid is at 10:00 in Bogotá on 23 October. Keeping 17:00 in Madrid on Monday 26 October moves it to 11:00 in Bogotá. That matters if the participant already has a call immediately afterwards.
To preserve 10:00 in Bogotá, use 16:00 Madrid time on 26 October. For weekly invitations, set the reference zone to the city whose local time must stay fixed, then inspect the first session after each transition.
Hourly table for 26 October 2026
The first column is Madrid local time. Check the destination date in the last column.
| Madrid | Bogotá | Destination date |
|---|---|---|
| 08:00 | 02:00 | 26 October 2026 |
| 09:00 | 03:00 | 26 October 2026 |
| 10:00 | 04:00 | 26 October 2026 |
| 11:00 | 05:00 | 26 October 2026 |
| 12:00 | 06:00 | 26 October 2026 |
| 13:00 | 07:00 | 26 October 2026 |
| 14:00 | 08:00 | 26 October 2026 |
| 15:00 | 09:00 | 26 October 2026 |
| 16:00 | 10:00 | 26 October 2026 |
| 17:00 | 11:00 | 26 October 2026 |
| 18:00 | 12:00 | 26 October 2026 |
| 19:00 | 13:00 | 26 October 2026 |
| 20:00 | 14:00 | 26 October 2026 |
Starting from Bogotá
Read the first column as Bogotá local time on each stated date. The Madrid columns include the destination date, including any rollover.
| Bogotá clock | Madrid · origin 24 October | Madrid · origin 26 October |
|---|---|---|
| 09:00 | 16:00 · 24 October 2026 | 15:00 · 26 October 2026 |
| 10:00 | 17:00 · 24 October 2026 | 16:00 · 26 October 2026 |
| 12:00 | 19:00 · 24 October 2026 | 18:00 · 26 October 2026 |
| 15:00 | 22:00 · 24 October 2026 | 21:00 · 26 October 2026 |
| 18:00 | 01:00 · 25 October 2026 | 00:00 · 27 October 2026 |
| 20:00 | 02:00 · 25 October 2026 | 02:00 · 27 October 2026 |
Convert from Bogotá to Madrid →
The time difference throughout 2026
These periods cover the Madrid calendar year. Starts are inclusive and ends are exclusive. Boundary times are written in Madrid local time with their UTC offset so that repeated hours remain unambiguous. A constant difference can hide a simultaneous clock change in both cities.
| From, inclusive | Until, exclusive | UTC Madrid | UTC Bogotá | Difference |
|---|---|---|---|---|
| 1 January 2026 · 00:00 (UTC+01:00) | 29 March 2026 · 03:00 (UTC+02:00) | UTC+01:00 | UTC−05:00 | Madrid +6 h |
| 29 March 2026 · 03:00 (UTC+02:00) | 25 October 2026 · 02:00 (UTC+01:00) | UTC+02:00 | UTC−05:00 | Madrid +7 h |
| 25 October 2026 · 02:00 (UTC+01:00) | 1 January 2027 · 00:00 (UTC+01:00) | UTC+01:00 | UTC−05:00 | Madrid +6 h |
The CSV contains every hour of 24 October, 26 October and 2 November, with each destination date and both UTC offsets in minutes. It is a reference table, not a live feed.
Common questions
How many hours apart are Spain and Colombia in October?
For Madrid and Bogotá in October 2026, seven hours before the Spanish change and six after it. The Canary Islands are one hour behind Madrid.
Does the destination date always match Madrid’s date?
No. A conversion near midnight can land on the previous day in Bogotá. The tables and tool include the date.
Sources and calculation
Tables are calculated using named IANA zones with Intl. Read the method, scope and limitations.