title: Show Current Time in Excel by Timezone
body: <p>I have searched all over and any answer or code I find is rather confusing.</p>
  
  <p>I am looking to convert the =NOW function in excel to a different timezone(s)</p>
  
  <p>I am currently using</p>
  
  <pre><code>=TEXT(NOW(), "hh:mm:ss AM/PM")
  </code></pre>
  
  <p>which displays my timezone EST</p>
  
  <p>I would like to convert this to another time zone</p>
  
  <p>for example PST.</p>
  
  <p>is there a way to do </p>
  
  <p><code>=TEXT IF C1 equals PST subtract 3 from A1 &lt;--- the current time</code></p>
  
  <p>what im trying to do is if one column has the letters PST in it I want to convert the =NOW by subtracting 3 hours from my EST Time Zone.</p>
  
  <p>sorry if my question is a little confusing.</p>
  
  <p>I know im not the only one searching this so an answer would help me and future users, thanks so much in advance.</p>
  
  <p>UPDATE:</p>
  
  <p>so I was able to use </p>
  
  <pre><code> =TEXT(NOW()-0.125, "hh:mm:ss AM/PM") 
  </code></pre>
  
  <p>to subtract 3 hours, but not make an if statement for 2 or more timezones</p>