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