Convert the date from PST to IST and output the difference in hour
Is there any way to automatically convert PST Date in to IST date. When I put date in column E and F I have dates in PST time zone. I want to convert in IST time zone. after i want output in column G. the difference between two dates.
I have solved this with excel formula but I want this to done with VBA.
> E F G
1/14/2016 2:49:00 PM 1/14/2016 2:57:00 PM 0:08
1/14/2016 2:45:00 PM 1/14/2016 2:59:00 PM 0:09