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: 7/3/20267/3/2026
Current Local Date:
7/3/2026
Calculations spanning DST transitions may be incorrect
6
Enter the Time: 7:17 PMDuration (hrs):310:17 PM
Current Local Time:
7:17 PM
Start/End dates cannot span multiple years
7
Date + Time: 7/3/26 7:17 PM7/3/26 10:17 PM
8
GMT: 7/4/26 1:17 AM7/4/26 4:17 AM
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: 1110001
16
17
18
19
20
21
22
23
Start Time: Fri 7:17 PMFri 8:17 PMFri 9:17 PMSat 10:17 AMFri 6:17 PMSat 11:17 AMSat 2:17 AM
24
End Time: Fri 10:17 PMFri 11:17 PMSat 12:17 AMSat 1:17 PMFri 9:17 PMSat 2:17 PMSat 5:17 AM
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 1:00 AMFri 2:00 AMFri 3:00 AMFri 4:00 PMFri 12:00 AMFri 5:00 PMFri 8:00 AM
35
Fri 8:00 AMFri 2:00 AMFri 3:00 AMFri 4:00 AMFri 5:00 PMFri 1:00 AMFri 6:00 PMFri 9:00 AM
36
Fri 9:00 AMFri 3:00 AMFri 4:00 AMFri 5:00 AMFri 6:00 PMFri 2:00 AMFri 7:00 PMFri 10:00 AM
37
Fri 10:00 AMFri 4:00 AMFri 5:00 AMFri 6:00 AMFri 7:00 PMFri 3:00 AMFri 8:00 PMFri 11:00 AM
38
Fri 11:00 AMFri 5:00 AMFri 6:00 AMFri 7:00 AMFri 8:00 PMFri 4:00 AMFri 9:00 PMFri 12:00 PM
39
Fri 12:00 PMFri 6:00 AMFri 7:00 AMFri 8:00 AMFri 9:00 PMFri 5:00 AMFri 10:00 PMFri 1:00 PM
40
Fri 1:00 PMFri 7:00 AMFri 8:00 AMFri 9:00 AMFri 10:00 PMFri 6:00 AMFri 11:00 PMFri 2:00 PM
41
Fri 2:00 PMFri 8:00 AMFri 9:00 AMFri 10:00 AMFri 11:00 PMFri 7:00 AMSat 12:00 AMFri 3:00 PM
42
Fri 3:00 PMFri 9:00 AMFri 10:00 AMFri 11:00 AMSat 12:00 AMFri 8:00 AMSat 1:00 AMFri 4:00 PM
43
Fri 4:00 PMFri 10:00 AMFri 11:00 AMFri 12:00 PMSat 1:00 AMFri 9:00 AMSat 2:00 AMFri 5:00 PM
44
Fri 5:00 PMFri 11:00 AMFri 12:00 PMFri 1:00 PMSat 2:00 AMFri 10:00 AMSat 3:00 AMFri 6:00 PM
45
Fri 6:00 PMFri 12:00 PMFri 1:00 PMFri 2:00 PMSat 3:00 AMFri 11:00 AMSat 4:00 AMFri 7:00 PM
46
Fri 7:00 PMFri 1:00 PMFri 2:00 PMFri 3:00 PMSat 4:00 AMFri 12:00 PMSat 5:00 AMFri 8:00 PM
47
Fri 8:00 PMFri 2:00 PMFri 3:00 PMFri 4:00 PMSat 5:00 AMFri 1:00 PMSat 6:00 AMFri 9:00 PM
48
Fri 9:00 PMFri 3:00 PMFri 4:00 PMFri 5:00 PMSat 6:00 AMFri 2:00 PMSat 7:00 AMFri 10:00 PM
49
Fri 10:00 PMFri 4:00 PMFri 5:00 PMFri 6:00 PMSat 7:00 AMFri 3:00 PMSat 8:00 AMFri 11:00 PM
50
Fri 11:00 PMFri 5:00 PMFri 6:00 PMFri 7:00 PMSat 8:00 AMFri 4:00 PMSat 9:00 AMSat 12:00 AM
51
Sat 12:00 AMFri 6:00 PMFri 7:00 PMFri 8:00 PMSat 9:00 AMFri 5:00 PMSat 10:00 AMSat 1:00 AM
52
Sat 1:00 AMFri 7:00 PMFri 8:00 PMFri 9:00 PMSat 10:00 AMFri 6:00 PMSat 11:00 AMSat 2:00 AM
53
Sat 2:00 AMFri 8:00 PMFri 9:00 PMFri 10:00 PMSat 11:00 AMFri 7:00 PMSat 12:00 PMSat 3:00 AM
54
Sat 3:00 AMFri 9:00 PMFri 10:00 PMFri 11:00 PMSat 12:00 PMFri 8:00 PMSat 1:00 PMSat 4:00 AM
55
Sat 4:00 AMFri 10:00 PMFri 11:00 PMSat 12:00 AMSat 1:00 PMFri 9:00 PMSat 2:00 PMSat 5:00 AM
56
Sat 5:00 AMFri 11:00 PMSat 12:00 AMSat 1:00 AMSat 2:00 PMFri 10:00 PMSat 3:00 PMSat 6:00 AM
57
Sat 6:00 AMSat 12:00 AMSat 1:00 AMSat 2:00 AMSat 3:00 PMFri 11:00 PMSat 4:00 PMSat 7:00 AM
58
Sat 7:00 AMSat 1:00 AMSat 2:00 AMSat 3:00 AMSat 4:00 PMSat 12:00 AMSat 5:00 PMSat 8:00 AM
59
Sat 8:00 AMSat 2:00 AMSat 3:00 AMSat 4:00 AMSat 5:00 PMSat 1:00 AMSat 6:00 PMSat 9:00 AM
60
Sat 9:00 AMSat 3:00 AMSat 4:00 AMSat 5:00 AMSat 6:00 PMSat 2:00 AMSat 7:00 PMSat 10:00 AM
61
Sat 10:00 AMSat 4:00 AMSat 5:00 AMSat 6:00 AMSat 7:00 PMSat 3:00 AMSat 8:00 PMSat 11:00 AM
62
Sat 11:00 AMSat 5:00 AMSat 6:00 AMSat 7:00 AMSat 8:00 PMSat 4:00 AMSat 9:00 PMSat 12:00 PM
63
Sat 12:00 PMSat 6:00 AMSat 7:00 AMSat 8:00 AMSat 9:00 PMSat 5:00 AMSat 10:00 PMSat 1:00 PM
64
Sat 1:00 PMSat 7:00 AMSat 8:00 AMSat 9:00 AMSat 10:00 PMSat 6:00 AMSat 11:00 PMSat 2:00 PM
65
Sat 2:00 PMSat 8:00 AMSat 9:00 AMSat 10:00 AMSat 11:00 PMSat 7:00 AMSun 12:00 AMSat 3:00 PM
66
Sat 3:00 PMSat 9:00 AMSat 10:00 AMSat 11:00 AMSun 12:00 AMSat 8:00 AMSun 1:00 AMSat 4:00 PM
67
Sat 4:00 PMSat 10:00 AMSat 11:00 AMSat 12:00 PMSun 1:00 AMSat 9:00 AMSun 2:00 AMSat 5:00 PM
68
Sat 5:00 PMSat 11:00 AMSat 12:00 PMSat 1:00 PMSun 2:00 AMSat 10:00 AMSun 3:00 AMSat 6:00 PM
69
Sat 6:00 PMSat 12:00 PMSat 1:00 PMSat 2:00 PMSun 3:00 AMSat 11:00 AMSun 4:00 AMSat 7:00 PM
70
Sat 7:00 PMSat 1:00 PMSat 2:00 PMSat 3:00 PMSun 4:00 AMSat 12:00 PMSun 5:00 AMSat 8:00 PM
71
Sat 8:00 PMSat 2:00 PMSat 3:00 PMSat 4:00 PMSun 5:00 AMSat 1:00 PMSun 6:00 AMSat 9:00 PM
72
Sat 9:00 PMSat 3:00 PMSat 4:00 PMSat 5:00 PMSun 6:00 AMSat 2:00 PMSun 7:00 AMSat 10: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