formula to add PST or PDT timezone to NOW() function

[Bobbbo]

A create a time and date stamp and I need to let people know what timezone I am in whether we are in daylight saving (PDT) or standard time (PST) when I use the NOW() function. Is there a formula I can use to add that PST or PDT extension to the time?

[CAntosh]

I don't know that there's an official format for timezones, but you could force it with something like:

=TEXT(NOW(),"mm/dd/yyyy mm:hh:ss")&IF(AND(TODAY()>=5/12/2017,TODAY()<11/5/2017)," PDT"," PST")

Which spits out:

02/10/2017 02:15:39 PST

[Bobbbo]

I don't know that there's an official format for timezones, but you could force it with something like:

=TEXT(NOW(),"mm/dd/yyyy mm:hh:ss")&IF(AND(TODAY()>=5/12/2017,TODAY()<11/5/2017)," PDT"," PST")

Which spits out:

02/10/2017 02:15:39 PST

Hi CAntoch, that is exactly what I needed. It will work until they change the date on which Daylight savings is on or off! Thanks so much!