I have a problem with the time zone for New York (USA), because when I use the code with a negative number -4 for the time difference from Norway ((#DUH#-4)%24):#DmZ# it does not show the correct time when it comes to midnight. As long as you put in a positive number it all works very well on any other time zone that’s ahead of Norway. Can anybody please tell me why and help me with solving this issue?
Have a look at this thread:
Maybe that will help…
I think you need to add 24 to any negative time zone offset for the formula to work both directions
Thanks again for answering my questions, I hope I am not bothering you to much. Great to see all the positivity in this forum .
It worked great, just had to ad +20 instead of +18 from the time in Norway, will check it later, so thank you again.
Welcome to the Community, where you’ve already found out that there’s lots to learn and plenty of helpful people too
Just great, love it