Loading
Extend Salesforce with Clicks, Not Code
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          TIMEVALUE

          TIMEVALUE

          Returns the time value without the date, such as business hours.

          Use

          TIMEVALUE(value) and replace value with a date/time or text value, merge field, or expression.

          Tips

          • The displayed value is formatted based on the org’s Locale settings.
          • Don’t use TIMEVALUE on a time field. A time field’s value is already in time format. For example, for a time field with an API name timefield__c, TIMEVALUE(timefield__c) doesn’t do anything.
          • TIMEVALUE converts the input value to the time in GMT. This function doesn’t take the user’s time zone into account.
          Time Example
          Time Example

          TIMEVALUE(ClosedDate) displays a time value based on the value of the Date/Time Closed field.

          TIMEVALUE("17:30:45.125") returns 5:30 PM.

           
          Loading
          Salesforce Help | Article