TimeValue

Calculates a time. The TimeValue function expects the argument value (Time) to be a string or any expression that can represent a time value.

Syntax

TimeValue(Time)

Time:

A string or expression that can represent a time value. This includes and combination of time literals, numbers that look like times, strings that look like times, and times from functions.

Return Value

Returns a variant (of date data type) corresponding to the parameter (Time).

Related Functions

DateValue

Example

Dim varMyTime
varMyTime = TimeValue("2:35:17 PM")
' stores time as 14:35:17