Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to convert reload() time into CET zone and tried below logic however, it is not working.
=ConverttoLocaltime(reloadtime(),'UTC+01:00')
Reloadtime() is CST zone (usa).
Thanks,
Nihhal.
As the difference between CET and CST is 7 hours, I think you just want to add 7 hours.
TimeStamp(ReloadTime() + MakeTime(7))
-Rob
As the difference between CET and CST is 7 hours, I think you just want to add 7 hours.
TimeStamp(ReloadTime() + MakeTime(7))
-Rob
Nihhal,
What is the problem you are seeing exactly?
I understand your need to use ConvertToLocalTime since we in the US like to use daylight savings during summer months.
This thread Convert to GMT with DST adjustment will help. Finding the right major US city/time zone to use in the DST adjustment is the fun part. I've tested this with 'Baja California' and it worked for me:
ConvertToLocalTime('2017-08-29 10:30:00','Baja California',0) will be 1 hour different than ConvertToLocalTime('2017-08-29 10:30:00','Baja California',1). Note the DST flag either 0 or 1.
Also, note that the conversion will only appear to work during DST months. If I did the same above to today's date it would not change.
--john
Thanks Rob.
Hey Rob, does CET use daylight savings? I mean, when the US "Springs Forward" or "Falls Back" does CET follow suit? If so, I agree with you. If not, then this method will be 1 hour off half the year.
--john
How about daylight saving time when i have to convert CST to Hawaii time.