I am working on a formula based on a date/time value to extract the time for the field. This field is based on the Pacific Time Zone and as is appears as
04/04/2016 9:00 PM
I set up this formula below
LEFT(RIGHT(text( HOC__End_Date_Time__c ),9),7)
However the return result is based on GMT and returns based on a 24-hour clock, is there a way to adjust so it can simply display as 9:00 PM rather than as 24:00.
Hope it helps.