Changing ReloadTime() from Germany Time zone to New York Time zone

[su_pyae]

Hello everyone, 

I am having issues with converting my reload time to New York Time Zone. 

My reload time is always in Germany Time Zone. I am using this formula to change it into New York Time Zone: Time(ConvertToLocalTime(ReloadTime(), 'GMT-04:00'),'h:mm TT')

For example, I reloaded my data at 1:55 PM (my time) but when I use ReloadTime(), it will give me 10:55 PM which is the data reload time, using Germany Time Zone. 

When I convert it using 'GMT-04:00' to get it in NY time, 6:55 PM which is wrong. It should be 4:55 PM since CA and NY have only 3 hours difference and NY and Germany have 6 hours difference. 

Please let me know what I did wrong. 

Thank you!

[vinieme12 · Accepted solution]

its 6hrs difference so it shoudl be GMT-6

=Time(ConvertToLocalTime(ReloadTime(), 'GMT-06:00'),'h:mm TT')