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.

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

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.

Did this article solve your issue?

Let us know so we can improve!