

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Timezone Convert
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.
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As the difference between CET and CST is 7 hours, I think you just want to add 7 hours.
TimeStamp(ReloadTime() + MakeTime(7))
-Rob


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As the difference between CET and CST is 7 hours, I think you just want to add 7 hours.
TimeStamp(ReloadTime() + MakeTime(7))
-Rob


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Rob.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How about daylight saving time when i have to convert CST to Hawaii time.
