I need the tag for a GMT hand based on the user’s time zone. I have scratched my head with this one, but plumbing is not my strong suit! Assistance will be highly appreciated. Thank you.
Maybe this helps to start with:
But I found using UTC tags confusing because the hours can be 0-11 or 1-12. So what does hand need to point to?
I have used the following formula for
24 hour hand: (#DNOW#/1000/60/60*360/24)
12 hour hand: (#DNOW#/1000/60/60*360/12)
If you want to add the timezone to that, is a bit more complicated. Check here:
Thanks so much Tom. I’m going to try a combination of these tags and see. I’ll report back here when I’m done.
Tom’s masterclass…
I used the 12-hour hand tag: (#DNOW#/1000/60/60*360/12) and it works like a charm. Users are asking me about settings for their time zones. That is the challenge that I am facing.
OK, there is a way.
the 12H formula can also be re-written as follows (looks a little less complex):
(((#DNOW#/3.6e6)%12)*30)
Now, if you want to add the UTC value to it, the issue is that UTC ranges from -11 to +12. Negative values is not ideal so I’ll add 24h to it. For rotation of a hand it does not matter what day it is…, the formula now looks like this:
((((#DNOW#/3.6e6)+24+X)%12)*30)
X is what ever UTC value you want to put in there. If you have premium, you could replace the X with #VAR_1# for example and choose the UTC on the fly…
UTC Should not change . I like the 3.6e6 . Reminds me of PAUSE 4e4 on Sinclair Basic .