Excel time zone chart4/6/2024 For example: Pacific Standard Time (PST), Hong Kong Time (HKT), Central European Time (CET), Central European Summer Time (CEST). I like both the long, spelled out version and the three-letter abbreviation. Depending on how many time zones we are passing in a trip block, if things get full and I can’t print it all on one page, I can merge things together pretty quick by the UTC offset. I prefer to list HKT and MYT in their own columns with UTC +8 at the top of both, letting me know quickly they are the same actual time. For example, Hong Kong Time (HKT) and Malaysian Time (MYT) are both UTC +8. It is actually pretty common for countries to have their own names for the same UTC offset, especially when dealing with Daylight Savings Time. I also will include if we will encounter any Daylight Savings (in or out) both in the US and in other places (which obviously never match up with US time changes - that would be too easy!). I include every time zone we will visit in each trip block (what we call a US -> other places -> US loop). Since our work time zone (Pacific) is the most important, it always goes on the far left. The general format of the spreadsheet is the same every time.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |