The DST schedule in Canada synchronized with the USA. UTC-07:00 Pacific Time Zone (Pacific Daylight Time) covers entire Yukon (YT).Īlmost all the provinces of Canada apply the Daylight Saving Time (DST) in the warm period of the year, excluding the most territory of Saskatchewan (SK) and some exceptions in British Columbia (BC), Yukon (YT), Ontario (ON), Quebec (QC) and Nunavut (NU).UTC-08:00 Pacific Time Zone (Pacific Standard Time) covers most of British Columbia (BC).UTC-07:00 Mountain Time Zone comprises wholly Alberta (AB) and Northwest Territories (NT), also the western part of Nunavut (NU), the small exception in Saskatchewan (SK), the eastern and southeastern districts of British Columbia (BC).UTC-06:00 Central Time Zone includes entire Manitoba (MB), Saskatchewan (SK) with small exception and quite a big piece of Nunavut (NU).UTC-05:00 Eastern Time Zone encompasses the eastern part of Nunavut (NU), most of Ontario (ON) and Quebec (QC) provinces.UTC-04:00 Atlantic Time Zone comprises most of Labrador and three other provinces - New Brunswick (NB), Nova Scotia (NS), Prince Edward Island (PE).UTC-03:30 Newfoundland Time Zone includes the entire island of Newfoundland and the southeastern part of the Labrador region.Legally all matters concerning local time are officially regulated by the provincial legislation and decisions of the municipalities, that's why in practice many exceptions apply in some provinces.
#UTC TIME CODES SERIAL#
Because it’s an Excel serial date value, comparing to another date/time is simple time. With the formula GimmeUTC () you get Excel serial date/time value.
Put the function in a Module for the worksheet: In the worksheet, the custom function will appear as you type a formula. There are 6 standard time zones in Canada, and 4 of them are the same as in the USA. The code is simple enough for even VBA novices to understand.