Time Zone Indicator on or for IF NOW Time Stamp

[JEH105]

Hi! I currently have the following auto-timestamp formula set on a TIME column.

=IF($U2<>"",IF($T2<>"",$T2,NOW()),"")

Users in different time zones utilize this tracker. I want to do one of the following:

A: Add a formula that returns the time zone of the timestamp recorded in the TIME column. (e.g. TIME ZONE column = CST, IST, PST, etc.)

OR

B: Add a time zone identifier to the existing timestamp formula in the TIME column.

Does anyone know how to achieve one or the other without VBA?

Thank you so much for your time!

 

[James006]

Hi,

Everything depends on what you actually call Time Zone ...

To go from your Reference Time to whatever other " Time Zone", you will need a Difference/Adjustment expressed by a Number of Hours

To get the Adjusted Time in the other zone :

=MOD(Reference Time+(Number of Hours/24),1)