City comparison · time difference and converter
Shanghai is 13 hours ahead of Barranquilla right now. Barranquilla sits in Colombia on Bogota; Shanghai sits in China on Shanghai. They are roughly 15,013 km apart (9,329 mi), a flight of about 18h 40m. Barranquilla's metro holds around 1.2 million people; Shanghai's around 26.3 million.
Slot 1
00:00 / 13:00
Barranquilla / Shanghai
Partial overlapSlot 2
01:00 / 14:00
Barranquilla / Shanghai
Partial overlapSlot 3
02:00 / 15:00
Barranquilla / Shanghai
Partial overlapEach row is one hour in Barranquilla. Green rows are inside business hours in both cities; amber means only one side is at their desk; grey rows fall outside business hours in both.
Corpus Christi
Barranquilla, Colombia
Mon, Jun 8
Sacred Heart
Barranquilla, Colombia · Sagrado Corazón
Mon, Jun 15
Dragon Boat Festival
Shanghai, China · 端午节
Fri, Jun 19
Saint Peter and Saint Paul
Barranquilla, Colombia · San Pedro y San Pablo
Mon, Jun 29
Great-circle distance
15,013 km
(9,329 mi)
Approximate flight
18h 40m
850 km/h cruise + 1h taxi/climb/descent
Jet lag
13h
Roughly 1 day to adjust per timezone crossed
The heatmap gives you the shape of the day. If you need to convert one specific hour — say a customer call or a release window — open the converter with both cities already loaded.
Open in converter →The difference between Barranquilla and Shanghai is not really a number, it's a daily rhythm. Shanghai is 13 hours ahead of Barranquilla on the clock today, but the lived version is that Shanghai is wrapping up the working day while Barranquilla is still in the morning, and the overlap people actually use is narrow. That gap, more than the raw offset, is what teams have to design around.
In Barranquilla, the working day picks up earliest in the financial districts — Barranquilla's downtown core wakes early and breaks for lunch at the usual hour. The mood in Shanghai is its own story: Shanghai settles into the evening at the usual hour, with the local commuter pattern setting the pace. If you are scheduling between the two, the heatmap above marks the rows where both patterns line up.
Daylight saving is the other thing to keep an eye on. Colombia either observes DST or holds a fixed offset year-round; China either follows its region's DST pattern or stays put all year. When the two changes are weeks apart, the offset between Barranquilla and Shanghai is one hour off the usual for that stretch — a cliff that catches recurring calendar invites unless your calendar app rebases them automatically. Pin the meeting to a city, not an offset, and the tool handles the rest.
For travellers, the 18h 40m flight is the short version of the story. The longer one is jet lag: roughly one day of adjustment per timezone crossed, which means a trip across the 13-hour gap costs about 13 groggy days on each side. Pilots and cabin crew swear by morning sunlight and an early walk; whatever your routine, the wall-clock numbers above are the source of truth for your first morning in the new city.