ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
World Meeting Planner and Time Zone Converter
2
https://www.vertex42.com/ExcelTemplates/world-meeting-planner.html
© 2016 Vertex42 LLCInstructions
3
1) Edit cells with gray borders
4
STARTEND
2) Read cell comments (red triangles) for more info
5
Enter the Date: 2/6/20262/6/2026
Current Local Date:
2/6/2026
Calculations spanning DST transitions may be incorrect
6
Enter the Time: 8:18 AMDuration (hrs):311:18 AM
Current Local Time:
8:18 AM
Start/End dates cannot span multiple years
7
Date + Time: 2/6/26 8:18 AM2/6/26 11:18 AM
8
GMT: 2/6/26 3:18 PM2/6/26 6:18 PM
9
Your Time Zone
10
Enter Locations: DenverSt. LouisNew YorkTokyo, JapanArizonaSydney, AULondon, UK
11
Enter UTC Offsets: -7-6-59-7100
Look up UTC Offset on wikipedia
12
Choose DST Rules: US/CanadaUS/CanadaUS/CanadaNo DSTNo DSTAustraliaUK/Germany
See DST Rules worksheet
13
DST Begin: 3/8/20263/8/20263/8/2026n/an/a10/4/20263/29/2026
14
DST End: 11/1/202611/1/202611/1/2026n/an/a4/5/202610/25/2026
15
DST Offset: 0000010
16
17
18
19
20
21
22
23
Start Time: Fri 8:18 AMFri 9:18 AMFri 10:18 AMSat 12:18 AMFri 8:18 AMSat 2:18 AMFri 3:18 PM
24
End Time: Fri 11:18 AMFri 12:18 PMFri 1:18 PMSat 3:18 AMFri 11:18 AMSat 5:18 AMFri 6:18 PM
25
26
Availability Start: 6:00 AM6:00 AM6:00 AM6:00 AM6:00 AM6:00 AM6:00 AMAvailability -Hrs1
27
Availability End: 6:00 PM6:00 PM6:00 PM6:00 PM6:00 PM6:00 PM6:00 PMAvailability +Hrs3
28
29
Time Comparison Table
33
UTC TimeDenverSt. LouisNew YorkTokyo, JapanArizonaSydney, AULondon, UK
34
Fri 7:00 AMFri 12:00 AMFri 1:00 AMFri 2:00 AMFri 4:00 PMFri 12:00 AMFri 6:00 PMFri 7:00 AM
35
Fri 8:00 AMFri 1:00 AMFri 2:00 AMFri 3:00 AMFri 5:00 PMFri 1:00 AMFri 7:00 PMFri 8:00 AM
36
Fri 9:00 AMFri 2:00 AMFri 3:00 AMFri 4:00 AMFri 6:00 PMFri 2:00 AMFri 8:00 PMFri 9:00 AM
37
Fri 10:00 AMFri 3:00 AMFri 4:00 AMFri 5:00 AMFri 7:00 PMFri 3:00 AMFri 9:00 PMFri 10:00 AM
38
Fri 11:00 AMFri 4:00 AMFri 5:00 AMFri 6:00 AMFri 8:00 PMFri 4:00 AMFri 10:00 PMFri 11:00 AM
39
Fri 12:00 PMFri 5:00 AMFri 6:00 AMFri 7:00 AMFri 9:00 PMFri 5:00 AMFri 11:00 PMFri 12:00 PM
40
Fri 1:00 PMFri 6:00 AMFri 7:00 AMFri 8:00 AMFri 10:00 PMFri 6:00 AMSat 12:00 AMFri 1:00 PM
41
Fri 2:00 PMFri 7:00 AMFri 8:00 AMFri 9:00 AMFri 11:00 PMFri 7:00 AMSat 1:00 AMFri 2:00 PM
42
Fri 3:00 PMFri 8:00 AMFri 9:00 AMFri 10:00 AMSat 12:00 AMFri 8:00 AMSat 2:00 AMFri 3:00 PM
43
Fri 4:00 PMFri 9:00 AMFri 10:00 AMFri 11:00 AMSat 1:00 AMFri 9:00 AMSat 3:00 AMFri 4:00 PM
44
Fri 5:00 PMFri 10:00 AMFri 11:00 AMFri 12:00 PMSat 2:00 AMFri 10:00 AMSat 4:00 AMFri 5:00 PM
45
Fri 6:00 PMFri 11:00 AMFri 12:00 PMFri 1:00 PMSat 3:00 AMFri 11:00 AMSat 5:00 AMFri 6:00 PM
46
Fri 7:00 PMFri 12:00 PMFri 1:00 PMFri 2:00 PMSat 4:00 AMFri 12:00 PMSat 6:00 AMFri 7:00 PM
47
Fri 8:00 PMFri 1:00 PMFri 2:00 PMFri 3:00 PMSat 5:00 AMFri 1:00 PMSat 7:00 AMFri 8:00 PM
48
Fri 9:00 PMFri 2:00 PMFri 3:00 PMFri 4:00 PMSat 6:00 AMFri 2:00 PMSat 8:00 AMFri 9:00 PM
49
Fri 10:00 PMFri 3:00 PMFri 4:00 PMFri 5:00 PMSat 7:00 AMFri 3:00 PMSat 9:00 AMFri 10:00 PM
50
Fri 11:00 PMFri 4:00 PMFri 5:00 PMFri 6:00 PMSat 8:00 AMFri 4:00 PMSat 10:00 AMFri 11:00 PM
51
Sat 12:00 AMFri 5:00 PMFri 6:00 PMFri 7:00 PMSat 9:00 AMFri 5:00 PMSat 11:00 AMSat 12:00 AM
52
Sat 1:00 AMFri 6:00 PMFri 7:00 PMFri 8:00 PMSat 10:00 AMFri 6:00 PMSat 12:00 PMSat 1:00 AM
53
Sat 2:00 AMFri 7:00 PMFri 8:00 PMFri 9:00 PMSat 11:00 AMFri 7:00 PMSat 1:00 PMSat 2:00 AM
54
Sat 3:00 AMFri 8:00 PMFri 9:00 PMFri 10:00 PMSat 12:00 PMFri 8:00 PMSat 2:00 PMSat 3:00 AM
55
Sat 4:00 AMFri 9:00 PMFri 10:00 PMFri 11:00 PMSat 1:00 PMFri 9:00 PMSat 3:00 PMSat 4:00 AM
56
Sat 5:00 AMFri 10:00 PMFri 11:00 PMSat 12:00 AMSat 2:00 PMFri 10:00 PMSat 4:00 PMSat 5:00 AM
57
Sat 6:00 AMFri 11:00 PMSat 12:00 AMSat 1:00 AMSat 3:00 PMFri 11:00 PMSat 5:00 PMSat 6:00 AM
58
Sat 7:00 AMSat 12:00 AMSat 1:00 AMSat 2:00 AMSat 4:00 PMSat 12:00 AMSat 6:00 PMSat 7:00 AM
59
Sat 8:00 AMSat 1:00 AMSat 2:00 AMSat 3:00 AMSat 5:00 PMSat 1:00 AMSat 7:00 PMSat 8:00 AM
60
Sat 9:00 AMSat 2:00 AMSat 3:00 AMSat 4:00 AMSat 6:00 PMSat 2:00 AMSat 8:00 PMSat 9:00 AM
61
Sat 10:00 AMSat 3:00 AMSat 4:00 AMSat 5:00 AMSat 7:00 PMSat 3:00 AMSat 9:00 PMSat 10:00 AM
62
Sat 11:00 AMSat 4:00 AMSat 5:00 AMSat 6:00 AMSat 8:00 PMSat 4:00 AMSat 10:00 PMSat 11:00 AM
63
Sat 12:00 PMSat 5:00 AMSat 6:00 AMSat 7:00 AMSat 9:00 PMSat 5:00 AMSat 11:00 PMSat 12:00 PM
64
Sat 1:00 PMSat 6:00 AMSat 7:00 AMSat 8:00 AMSat 10:00 PMSat 6:00 AMSun 12:00 AMSat 1:00 PM
65
Sat 2:00 PMSat 7:00 AMSat 8:00 AMSat 9:00 AMSat 11:00 PMSat 7:00 AMSun 1:00 AMSat 2:00 PM
66
Sat 3:00 PMSat 8:00 AMSat 9:00 AMSat 10:00 AMSun 12:00 AMSat 8:00 AMSun 2:00 AMSat 3:00 PM
67
Sat 4:00 PMSat 9:00 AMSat 10:00 AMSat 11:00 AMSun 1:00 AMSat 9:00 AMSun 3:00 AMSat 4:00 PM
68
Sat 5:00 PMSat 10:00 AMSat 11:00 AMSat 12:00 PMSun 2:00 AMSat 10:00 AMSun 4:00 AMSat 5:00 PM
69
Sat 6:00 PMSat 11:00 AMSat 12:00 PMSat 1:00 PMSun 3:00 AMSat 11:00 AMSun 5:00 AMSat 6:00 PM
70
Sat 7:00 PMSat 12:00 PMSat 1:00 PMSat 2:00 PMSun 4:00 AMSat 12:00 PMSun 6:00 AMSat 7:00 PM
71
Sat 8:00 PMSat 1:00 PMSat 2:00 PMSat 3:00 PMSun 5:00 AMSat 1:00 PMSun 7:00 AMSat 8:00 PM
72
Sat 9:00 PMSat 2:00 PMSat 3:00 PMSat 4:00 PMSun 6:00 AMSat 2:00 PMSun 8:00 AMSat 9:00 PM
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103