Help Converting EST to Local User Time

[yastaaa]

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.

[Joseph_Seddik]

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  

[yastaaa]

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?

[Joseph_Seddik · Accepted solution]

1. Hour format will depend on the local time settings of each user's device. Based on this settings users will individually have either a 12-hours or 24-hours time format. If you change your own settings to 12-hours format you'll see AM/PM, but this will not affect the display each user has on his own device.
   
   
2. Yes, they are minutes.

[Steve]

This?

([PT] + "005:00:00" + (UTCNOW() - NOW()))