Date format showing two time zones?

[BlackieHamel]

I use the following Date Format

[$-en-US]dddd, mmmm d, yyyy h:mm AM/PM;@

which, when I enter : “5/10 13:00” reformats to “Friday, May 10, 2019, 1:00 pm.”

Is there any way I could get it to show this in two time zones, such as

“Friday, May 10, 2019, 1:00 pm. EDT / 10:00 am. PDT”?

Thanks -- Blackie
​

 

[jasonb75]

Formatting can not be used to change the value, only how it is displayed. 13:00 will always be 1:00 PM regardless of time zone.

You would need to enter a formula in another cell with to add or subtact the correct number of hours, then format it in the same way.

 

[BlackieHamel]

Okay -- thanks.
Blackie