![]() The Time Comparison Table is rounded to the nearest hour, so even though it highlights your meeting time, note that the shaded time is rounded to the hour. The lighter shade of red shows when they "might" be available and these areas are currently set as 1 hour before work and 4 hours after work (you can change that). The cells shaded red are the times that they are NOT available. You can enter their normal work hours above the table. The table at the bottom of the worksheet helps you see the availability times for people in different locations. Click the drop-down menu to select a different time zone. Time Zone: By default, Zoom will use your computer's time zone. For example, you can enter 15 in the minutes field. I named the rules using some common locations, but you can change the names if you want to. Start: Select a date and time for your meeting, but remember you can start your meeting at any time before the scheduled time. The DST rules do not have standard names, so you will need to identify the rule for your locations by looking up information on Wikipedia and choosing the correct rule based on the information and tables in the DST Rules worksheet. Time Converter and World Clock - Conversion at a Glance - Pick best time to schedule conference calls, webinars, online meetings and phone calls. I intentionally tried to keep the spreadsheet as simple as possible, so I didn't account for the time that DST starts (typically 2:00 am), and the rules only work for a single year (which is why I have a note about the planner not working for meetings spanning multiple years). There may be exceptions to that in reality, but they are rare, so I stuck with this assumption for now. There are even different rules for locations within a main time zone, such as Arizona.Įach rule defines the dates that DST begins and ends, and if a location is ON DST, then it is assumed that 1 hour is added to the UTC offset. The complexity of time zone conversion comes from Daylight Saving Time (DST) rules, which are different throughout the world. You can look up the Standard UTC Offset for your locations using the link to the wikipedia article included in the spreadsheet. ![]() In other words, "Standard" time refers to when the location is NOT on Daylight Saving Time. When you schedule a meeting with a colleague who also uses Clockwise, Clockwise will suggest times that work for both of you based on your time zones, Focus Time, and other meeting preferences. The "Standard" UTC Offset is the offset for the location in mid-winter. Clockwise is a time orchestration platform that helps you spend less time manually managing your calendar. You could enter a person's name if you wanted to. The labels are just labels, so it doesn't matter what you call each location. Every Time Zone and World Chat Clock are two tools that make scheduling meetings in different time zones visually pleasing. Then, every time the spreadsheet recalculates, such as after press F9, the dates and clocks will update to show the current time. The numbered buttons represent the hours of the day in YOUR time zone. Enter the formula =TODAY() in the start date field and =NOW()-TODAY() in the start time field.
0 Comments
Leave a Reply. |