Display Time Value in a Salesforce Report Using a Formula Field

To display the Time value, Administrators may choose to create a formula field that will display the time.  
 

1. Create a New field with the Data Type as “Formula” and return type as “Text”.
2. Select the Advanced Formula builder to use a syntax similar to the one below

Use the following formula syntax to extract the time from a DateTime field:

LEFT(RIGHT(TEXT(DateTimeField ± (X/24)), 9), 5)

— where ± means plus or minus depending on your timezone offset from GMT, and X is the number of hours offset.

For example, for PST (UTC-8), the formula would be: LEFT(RIGHT(TEXT(CreatedDate - (8/24)), 9), 5). This returns the time in 24-hour format. Add this formula field to your report to display time values.