Offset
The time difference between Auckland and Bogotá is 17 hours.
Auckland (NZST) is ahead of Bogotá (COT).
NZST: UTC+12
COT: UTC-5
Neither Auckland nor Bogotá is currently observing daylight saving time.
When to schedule
Standard business hours (9 AM–5 PM, Mon–Fri) in Auckland and Bogotá don't overlap on the same weekday. Bogotá is 17 hours behind Auckland.
Realistic options: hand off asynchronously, or stretch one side by an hour to catch the other team at the start or end of their day.
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.
New Zealand
- New Year's DayThu, Jan 1
- Day after New Year's DayFri, Jan 2
- Waitangi DayFri, Feb 6
- Good FridayFri, Apr 3
- Easter MondayMon, Apr 6
- Anzac DayMon, Apr 27
- King's BirthdayMon, Jun 1
- MatarikiFri, Jul 10
- Labour DayMon, Oct 26
- Christmas DayFri, Dec 25
- Boxing DayMon, Dec 28
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.
| Auckland | Bogotá | Day |
|---|---|---|
| 12:00 am | 7:00 am | -1 day |
| 1:00 am | 8:00 am | -1 day |
| 2:00 am | 9:00 am | -1 day |
| 3:00 am | 10:00 am | -1 day |
| 4:00 am | 11:00 am | -1 day |
| 5:00 am | 12:00 pm | -1 day |
| 6:00 am | 1:00 pm | -1 day |
| 7:00 am | 2:00 pm | -1 day |
| 8:00 am | 3:00 pm | -1 day |
| 9:00 am | 4:00 pm | -1 day |
| 10:00 am | 5:00 pm | -1 day |
| 11:00 am | 6:00 pm | -1 day |
| 12:00 pm | 7:00 pm | -1 day |
| 1:00 pm | 8:00 pm | -1 day |
| 2:00 pm | 9:00 pm | -1 day |
| 3:00 pm | 10:00 pm | -1 day |
| 4:00 pm | 11:00 pm | -1 day |
| 5:00 pm | 12:00 am | Same day |
| 6:00 pm | 1:00 am | Same day |
| 7:00 pm | 2:00 am | Same day |
| 8:00 pm | 3:00 am | Same day |
| 9:00 pm | 4:00 am | Same day |
| 10:00 pm | 5:00 am | Same day |
| 11:00 pm | 6:00 am | Same day |
Daylight saving time
Auckland observes daylight saving time; Bogotá does not. The offset between the two zones changes when Auckland transitions: on Sunday, September 27, 2026, clocks spring forward from NZST to NZDT.
See the daylight saving time page for transition dates across every time zone.
Daylight today
- Sunrise
- 7:28 AM
- Sunset
- 5:13 PM
- Day length
- 9h 45m
- Sunrise
- 5:44 AM
- Sunset
- 6:07 PM
- Day length
- 12h 23m
Daylight overlap: 3h 39m — 7:28 AM–11:07 AM in Auckland (2:28 PM–6:07 PM in Bogotá). Both locations are in daylight during this window.
Cities in these zones
Other cities in New Zealand Time
Other cities in Colombia Time
Browse all cities to see the current local time anywhere.
Airports in these zones
Airports in New Zealand Time
- AKL
- CHC
- WLG
Airports in Colombia Time
- BOG
- CLO
- EOH
- MDE
Related conversions
Common conversions
- What is 9:00 am Auckland in Bogotá?
- 9:00 am Auckland is 4:00 pm Bogotá, the previous day.
- What is 12:00 pm Auckland in Bogotá?
- 12:00 pm Auckland is 7:00 pm Bogotá, the previous day.
- What is 12:30 pm Auckland in Bogotá?
- 12:30 pm Auckland is 7:30 pm Bogotá, the previous day.
- What is 2:00 pm Auckland in Bogotá?
- 2:00 pm Auckland is 9:00 pm Bogotá, the previous day.
- What is 5:00 pm Auckland in Bogotá?
- 5:00 pm Auckland is 12:00 am Bogotá.
- What is 11:30 pm Auckland in Bogotá?
- 11:30 pm Auckland is 6:30 am Bogotá.