Auckland to Columbia time converter
Columbia is 17 hours behind Auckland. When it is 9:00 AM in Auckland, it is 4:00 PM (Mon, Oct 19) in Columbia.
11:26 PM in Auckland, Tuesday, October 20, 2026
Auckland to Columbia conversion table
Every hour of today in Auckland and the matching time in Columbia. Light rows are typical working hours (9:00–18:00).
| Auckland | Columbia |
|---|---|
| 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 |
| 6:00 PM | 1:00 AM |
| 7:00 PM | 2:00 AM |
| 8:00 PM | 3:00 AM |
| 9:00 PM | 4:00 AM |
| 10:00 PM | 5:00 AM |
| 11:00 PM | 6:00 AM |
Best time to call or meet
Both sides are at work from 9:00 AM – 11:00 AM in Auckland (4:00 PM – 6:00 PM in Columbia).
Daylight saving time and the difference
The difference changes during the year because Auckland and Columbia switch clocks on different dates:
- Oct 20, 2026 – Nov 1, 2026: -17h
- Nov 1, 2026 – Mar 14, 2027: -18h
- Mar 14, 2027 – Apr 4, 2027: -17h
- Apr 4, 2027 – Sep 26, 2027: -16h
- Sep 26, 2027 – Oct 20, 2027: -17h
Distance
Auckland and Columbia are 13,330 km (8,283 miles) apart in a straight line.
More conversions
Questions and answers
What is the time difference between Auckland and Columbia?
Columbia is 17 hours behind Auckland.
What time is it in Columbia when it is 9 AM in Auckland?
When it is 9:00 AM in Auckland, it is 4:00 PM (Mon, Oct 19) in Columbia.
When is the best time to call Columbia from Auckland?
Both sides are at work from 9:00 AM – 11:00 AM in Auckland (4:00 PM – 6:00 PM in Columbia).
Does the time difference between Auckland and Columbia change?
Yes, for part of the year, because daylight saving time starts and ends on different dates or applies on one side only.