Activity › Forums › Salesforce® Discussions › How can we get time from Date Time field in Salesforce? Salesforce® Discussions How can we get time from Date Time field in Salesforce? Posted by sushant on February 9, 2017 at 2:28 PM Hi All, How can we get time from Date Time field in Salesforce? Thanks Kumar replied 9 years, 3 months ago 2 Members · 1 Reply 1 Reply Kumar Member February 10, 2017 at 11:11 AM Hi Sushant, Try this formula, this works for any timezone (simply replace the +10 with whatever your timezone is relative to GMT): IF( ISBLANK(Departure_Date_Time__c ),”0″, TEXT(MOD(VALUE( Left( right( trim(TEXT(Departure_Date_Time__c) ),9),2))+10,24)) &”:”&mid(right( trim(TEXT(Departure_Date_Time__c) ),9),4,2) ) Replaced ‘Departure_Date_Time__c’ with your datetime field, hope this helps. Log In to reply. Public All Members My Connections Only Me PublicAll MembersMy ConnectionsOnly Me Public All Members My Connections Only Me