Timezone conversion in a Google spreadsheet
<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>