Columbia, MO to Barcelona: time difference
Barcelona is 7 h ahead of Columbia, MO. Live clocks for both, the working hours they share, and how each one sits against your own time.
+7 h
Your time
One day, 2 clocks
Drag along the band to read any hour in every place at once.
Columbia, MO 04:11 4:11 AM Barcelona 11:11 11:11 AM You –:–
04:11 4:11 AM
Central Daylight Time · UTC-5
☀️ 07:24 · 🌙 18:25
11:11 11:11 AM
Central European Summer Time · UTC+2
☀️ 08:09 · 🌙 19:05
·
+7 h
Barcelona is 7 h ahead of Columbia, MO.
When you, Columbia, MO and Barcelona are all at the desk
Pick the working hours below – the window every location shares appears once your time zone is known.
Working hours
🇺🇸 Columbia, MO
0 12 AM 1 1 AM 2 2 AM 3 3 AM 4 4 AM 5 5 AM 6 6 AM 7 7 AM 8 8 AM 9 9 AM 10 10 AM 11 11 AM 12 12 PM 13 1 PM 14 2 PM 15 3 PM 16 4 PM 17 5 PM 18 6 PM 19 7 PM 20 8 PM 21 9 PM 22 10 PM 23 11 PM
🇪🇸 Barcelona
7 7 AM 8 8 AM 9 9 AM 10 10 AM 11 11 AM 12 12 PM 13 1 PM 14 2 PM 15 3 PM 16 4 PM 17 5 PM 18 6 PM 19 7 PM 20 8 PM 21 9 PM 22 10 PM 23 11 PM 0 12 AM 1 1 AM 2 2 AM 3 3 AM 4 4 AM 5 5 AM 6 6 AM
📍 Your time
- Asleep
- Early
- Working hours
- Evening
- Both working
- Right now
Time zones side by side
| Detail | 🇺🇸 Columbia, MO | 🇪🇸 Barcelona |
|---|---|---|
| Local time | 04:11 | 11:11 |
| Local date | Tuesday, October 20, 2026 | Tuesday, October 20, 2026 |
| Time zone | Central Daylight Time | Central European Summer Time |
| UTC offset | UTC-5 | UTC+2 |
| Offset from Columbia, MO | — | +7 h |
| IANA zone | America/Chicago | Europe/Madrid |
| Daylight saving | On summer time → UTC-6, Nov 1, 01:00 | On summer time → UTC+1, Oct 25, 02:00 |
| Sunrise | 07:24 | 08:09 |
| Sunset | 18:25 | 19:05 |
| Daylight | 11 h 1 min | 10 h 56 min |
| People on this clock | 139,698 | 1,660,122 |
Compare Columbia, MO with another city
More comparisons with Columbia, MO: the time zones next to it and the far side of the clock.
Nearby time zones
Big time differences
Columbia, MO and Barcelona: common questions
What is the time difference between Columbia, MO, and Barcelona?
Barcelona is 7 hours ahead: it uses UTC+2, while Columbia is on UTC−5.
If it is 9:00 AM in Columbia, MO, what time is it in Barcelona?
At 9:00 AM in Columbia, clocks in Barcelona show 4:00 PM.
What time is it in Barcelona when it is 6:00 PM in Columbia, MO?
When it is 6:00 PM in Columbia, it is 1:00 AM (the next day) in Barcelona.
Is there a time when both Columbia, MO, and Barcelona are at work?
Yes: from 9:00 AM to 11:00 AM in Columbia (4:00 PM to 6:00 PM in Barcelona), the working days (9:00 AM–6:00 PM) overlap.
When does the date change in Barcelona compared with Columbia, MO?
The new day starts in Barcelona earlier: at 5:00 PM in Columbia it is already midnight there. Until 7:00 AM in Barcelona, Columbia is still on the previous day.
Is the time difference between Columbia, MO, and Barcelona the same all year?
No. Both places use summer time, but they switch on different dates, so for a while the gap changes. From October 25, 2026, Barcelona will be 6 hours ahead of Columbia.
