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. The "Standard" UTC Offset is the offset for the location in mid-winter. 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. Then, every time the spreadsheet recalculates, such as after press F9, the dates and clocks will update to show the current time. Enter the formula =TODAY() in the start date field and =NOW()-TODAY() in the start time field.
0 Comments
Leave a Reply. |