Offset
The time difference between Bandung and Madrid is 5 hours.
Bandung (WIB) is ahead of Madrid (CEST).
WIB: UTC+7
CEST: UTC+2
Madrid is currently observing daylight saving time; Bandung is not.
When to schedule
Business-hours overlap: 2 PM–5 PM in Bandung (9 AM–12 PM in Madrid).
Both teams are in working hours during this window on weekdays.
Suggested time: 3:00 PM Bandung (10:00 AM Madrid).
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.
Indonesia
- New Year's DayThu, Jan 1
- Good FridayFri, Apr 3
- Easter SundaySun, Apr 5
- Labour DayFri, May 1
- Ascension DayThu, May 14
- Pancasila DayMon, Jun 1
- Independence DayMon, Aug 17
- Christmas DayFri, Dec 25
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
About these zones
Quick reference
Full 24-hour conversion table — tap any time to open it in the converter.
| Bandung | Madrid | Day |
|---|---|---|
| 12:00 am | 7:00 pm | -1 day |
| 1:00 am | 8:00 pm | -1 day |
| 2:00 am | 9:00 pm | -1 day |
| 3:00 am | 10:00 pm | -1 day |
| 4:00 am | 11:00 pm | -1 day |
| 5:00 am | 12:00 am | Same day |
| 6:00 am | 1:00 am | Same day |
| 7:00 am | 2:00 am | Same day |
| 8:00 am | 3:00 am | Same day |
| 9:00 am | 4:00 am | Same day |
| 10:00 am | 5:00 am | Same day |
| 11:00 am | 6:00 am | Same day |
| 12:00 pm | 7:00 am | Same day |
| 1:00 pm | 8:00 am | Same day |
| 2:00 pm | 9:00 am | Same day |
| 3:00 pm | 10:00 am | Same day |
| 4:00 pm | 11:00 am | Same day |
| 5:00 pm | 12:00 pm | Same day |
| 6:00 pm | 1:00 pm | Same day |
| 7:00 pm | 2:00 pm | Same day |
| 8:00 pm | 3:00 pm | Same day |
| 9:00 pm | 4:00 pm | Same day |
| 10:00 pm | 5:00 pm | Same day |
| 11:00 pm | 6:00 pm | Same day |
Daylight saving time
Madrid observes daylight saving time; Bandung 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
- 5:58 AM
- Sunset
- 5:41 PM
- Day length
- 11h 44m
- Sunrise
- 6:46 AM
- Sunset
- 9:44 PM
- Day length
- 14h 58m
Daylight overlap: 5h 56m — 11:46 AM–5:41 PM in Bandung (6:46 AM–12:41 PM in Madrid). Both locations are in daylight during this window.
Cities in these zones
Other cities in Western Indonesia Time
Other cities in Central European Time
Browse all cities to see the current local time anywhere.
Airports in these zones
Airports in Western Indonesia Time
- CGK
- HLP
- SUB
- BDO
- KNO
- PLM
- SRG
Airports in Central European Time
- MAD
- BCN
Related conversions
Common conversions
- What is 9:00 am Bandung in Madrid?
- 9:00 am Bandung is 4:00 am Madrid.
- What is 12:00 pm Bandung in Madrid?
- 12:00 pm Bandung is 7:00 am Madrid.
- What is 12:30 pm Bandung in Madrid?
- 12:30 pm Bandung is 7:30 am Madrid.
- What is 2:00 pm Bandung in Madrid?
- 2:00 pm Bandung is 9:00 am Madrid.
- What is 5:00 pm Bandung in Madrid?
- 5:00 pm Bandung is 12:00 pm Madrid.
- What is 11:30 pm Bandung in Madrid?
- 11:30 pm Bandung is 6:30 pm Madrid.