Salesforce Docs Portal

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.