ConvertToLocalTime() giving 1hr variance as compared to actual time

[jimbe0]

Hi, If reloadtime() returns Europe time, for example 6am. Then, I try to ConvertToLocalTime(ReloadTime(), 'New Delhi') it should add 4.5 hours right and return 10:30 am? But it returns 11.30 am

What's the mistake?

[vinieme12]

use GMT+4:30

=ConvertToLocalTime(reloadTime(),'GMT+04:30')

if you need to include DST add the parameter as True/False

=ConvertToLocalTime(reloadTime(),'GMT+04:30',True)