4 timezones help

hello
im a newbie and i wanted to make a 4 cities watch

NYC
LA
SHENZEN CHINA
BRAZIL OFICIAL TIME (or the time from carrier /smartphone)

i use (#tag#-3) for nyc for example but some periods of the day it can appear a negative hour

any good soul can teach me?

Try this
UTC #DUh#:#DUmZ#
NYC $(#DUk#-5)<1?(24+#DUk#-5):(#DUk#-5)$:#DUmZ#
LA $(#DUk#-8)<1?(24+#DUk#-8):(#DUk#-8)$:#DUmZ#
Shenzhen $(#DUk#+8)<1?(24+#DUk#+8):(#DUk#+8)$:#DUmZ#
Brazil $(#DUk#-3)<1?(24+#DUk#-3):(#DUk#-3)$:#DUmZ#

1 Like

thanks im gonna try :smiley: