We have a column Time type [PT] where we enter time in HH:MM for USA EST Time (UTC=EST-5).
We would like to display the hour in user local time.
We are trying this formula and does not work.
[LT] = [PT] +12 -5 +USERTZOFFSET()
Also [PT] data is introduced and we don't know how to set AM or PM, so we need to add 12 in the formula above.
Thanks.
Solved! Go to Solution.
You should not add 12, this will not change your time display format but instead will effectively push all your time values 12 hours later. Instead you can simply just write AM and PM in a date field and it will be taken into account correctly.
As for your question, please look at this guide:
Get app user's real local time offset - Google Cloud Community
Hi,
Thanks.
Two things to add to the discussion: Military Time no AM PM. So don't know if Military Time can be changed to AM PM.
Also,
2. USERTZOFFSET() gives a value of 240. Seems that this is in minutes. Anyone can confirm?
This?
([PT] + "005:00:00" + (UTCNOW() - NOW()))
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |