Convert GMT/UTC timezone in Excel to EST, CST, MST, PST, AST and HST

There are six time zones across The United States: Hawaii-Aleutian time, Alaska time, Pacific time, Mountain time, Central time, and Eastern time.

You may want to at times convert GMT/UTC time zone into specific timezones in Excel. In such case you can make use of the formula Cell +/- GMT-OFFSET/24

GMT/UTC	Timezone	GMT	       12/25/22 12:00 AM	Formula
Eastern Standard Time	EST	GMT-5	12/24/22 7:00 PM	D1 - 5/24
Central Standard Time	CST	GMT-6	12/24/22 6:00 PM	D1 - 6/24
Mountain Standard Time	MST	GMT-7	12/24/22 5:00 PM	D1 - 7/24
Pacific Standard Time	PST	GMT-8	12/24/22 4:00 PM	D1 - 8/24
Alaskan Standard Time	AST	GMT-9	12/24/22 3:00 PM	D1 - 9/24
Hawaiian Standard Time	HST	GMT-10	12/24/22 2:00 PM	D1 - 10/24

Note: You also need to make into account Daylight Saving Time (DST),

GMT/UTC	Timezone	GMT	       10/25/22 12:00 AM	Formula
Eastern Daylight Time	EDT	GMT-4	10/24/22 8:00 PM	D1 - 4/24
Central Daylight Time	CDT	GMT-5	10/24/22 7:00 PM	D1 - 5/24
Mountain Daylight Time	MDT	GMT-6	10/24/22 6:00 PM	D1 - 6/24
Pacific Daylight Time	PDT	GMT-7	10/24/22 5:00 PM	D1 - 7/24
Alaskan Daylight Time	ADT	GMT-8	10/24/22 4:00 PM	D1 - 8/24
Hawaiian Daylight Time	HDT	GMT-9	10/24/22 3:00 PM	D1 - 9/24