TimeValue
ReturnsDateChild typeVariant.
TimeValue (Time)
TimeA parameter is A string expression (including 0:00:00 and 12:00:00) from 23:59:59 (11:59:59 a.m.) to 0:00:00 (23:59:59 p.m ). However,TimeIt can also be an expression that represents any time in the range. IfTimeIf the parameter contains Null, returnNull.
Description
You can enter the time in 12 or 24-hour clock format. For example, "PM" and "" are both valid.TimeParameters. IfTimeThe parameter contains date information,TimeValueThe function does not return date information. However, ifTimeIf the parameter contains invalid date information, an error occurs.
The following example usesTimeValueThe function converts a string to time. You can also use the date text to directly assign timeVariantType variables (for example, MyTime = #4:35:17 #).
Dim MyTimeMyTime =TimeValue ("4:35:17")'MytimeInclude"4:35:17".