Use only the time of the DATETIME field in a formula

[mccortes10]

Hi, 

I need to have a formulated field where if the time in the field "start date" is 6 am it returns "ET" and if it is 12 pm returns "PT"

[kuovonne]

SWITCH(

  HOUR(SET_TIMEZONE({Start Date}, "timezone name")),

6, "ET",

  12, "PT"

)

You can find names of time zones here.