Displying Local time, also a different time zone not affected by location

I want to display my local time (no need for help here)
.
I also want to display another time zone (-7 from my time zone) in a prefered 12hr format with AM/PM indacators. This is where I need help. I am not an expression person at all!
.
Example: My Local Time: 12:00pm (represented by #Db#:#DmZ# with an AM/PM tag)
East Africa Time: 7:00pm
.
Is there a way I can take #Db#:#DmZ# and modify it for different time zones?
Or is a different starting expression needed?
I have no clue
.
And once I have the expression, I would like know what to change if I want a different time zone.

Thanks in advance for any help… I do save this kind of help in a WORD Docx to use again.

2 Likes

Yes you can find plenty on info on that topic here when you use search. Try this ((#Dh#-7+24)%24):#DmZ#

3 Likes

Thanks…
I fettled a bit to display in 12hr format…
((#Dh#-7+24)%11):#DmZ#

1 Like

Try this one. Its down side is, the abbreviations AM/PM willl not be localized.
Other thing is, it will be working just in your timezone. For everywhere else in the world it will show
local timezone -7. If you want to fixate it to some particular timezone, you would need to relate its ofset to #DUH# instead of #DH#
$(#DH#-7+24)%12==0?12:(#DH#-7+24)%12$:#DmZ# $(#DH#-7+24)%24<12?AM:PM$

4 Likes

Love following these informative threads thanks :+1:

1 Like