title: Timezone conversion in a Google spreadsheet
body: <p>I know this looks simple.</p>
  
  <p>In a Google spreadsheet, I have a column where I enter time in one timezone (GMT)
  And another column should automatically get time in another time zone(Pacific Time)</p>
  
  <pre><code> GMT      | PT
  ----------|------------
   5:00 AM  | 9:00 PM
  </code></pre>
  
  <p>As of now I am using </p>
  
  <pre><code> =$C$3-time(8,0,0)
  </code></pre>
  
  <p>The problem here is, I want to change the time formula for Daylight savings.</p>
  
  <p>Is there any function or script available which can take the daylight saving into calculation automatically.</p>