Time Zone problems

[petruuccios]

@g.orloff

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.

I think you need to add 24 to any negative time zone offset for the formula to work both directions

How do I display the Central Time Zone no matter where I am in the world?

Hello I think it is not so difficult. We solved here the zero crossing on multiple purposes, being it a day in year or seconds minutes hours before and after current one. The key is modulo and not using negative but positive difference in the shifted period like ((#DUH#+18)%24). Think of it like adding the time it would be there at UTC midnight, then calculating the reminder of division by the day period (24h).