Hi Fotis1991
your formula is working fine with me except one single problem.
with this formula I am copying one date.the date is in PST format I am trying to convert in IST by adding 12:30:00
but it is not giving any value.is there any other solution.
please check the Sheet "Assign window" in "D" i have entered your formula
and in D i want the IST time. but it is not giving any value