Calculate different time zone times only knowing what time zone you are in.

[donnamkelley]

I have the following information:

Depart Time	Time Zone	My Time	My Time Zone
7:00 AM	ET	FALSE	CT
8:00 AM	ET		MT
9:15 AM	ET		PT

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

How do I get Excel to tell what time it is in my time zone? I will need this to work east to west and west to east. I appreciate any help offered.

 

[Eric W]

Welcome to the board.

	A	B	C	D	E	F
1	Depart Time	Time Zone	My Time	My Time Zone		ET
2	7:00 AM	ET	6:00 AM	CT		CT
3	8:00 AM	ET	6:00 AM	MT		MT
4	9:15 AM	ET	6:15 AM	PT		PT
5	1:00 PM	MT	2:00 PM	CT
6	2:30 PM	PT	5:30 PM	ET

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet10​

Worksheet Formulas Cell Formula C2 =A2+(MATCH(B2,$F$1:$F$4,0)-MATCH(D2,$F$1:$F$4,0))/24 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Put a list of the time zones in order in F1:F4. Then the formula in C2 should work for you. You may have issues with times near midnight, but that's fixable if you want to include a date with the time.

Let me know how this works.

 

[donnamkelley]

Works perfectly, Eric. Thank you so much!

 

[Eric W]

Glad to help!