Excel 2007 : Formula to convert PST into IST (Time)

**Chetan Chauhan** · 04-07-2011, 06:47 AM

Hi,

Can anyone help me getting formula to convert Pacific Standard Time (PST) into Indian Standard Time (IST). The result should show time in AM/PM

Thanks in advance.

**teylyn** · 04-07-2011, 07:14 AM

Hello,

Look up the time difference between PST and IST and add (or subtract) the respective hours.

If the time value is in A1, then use for addition of 3 hours, for example

=a1+TIME(3,0,0)