Export (0) Print
Expand All

TimeValue Function

Returns a Date value containing the time information represented by a string, with the date information set to January 1 of the year 1.

Public Function TimeValue(ByVal StringTime As String) As DateTime

Parameter

StringTime
Required. String expression representing a date/time value from 00:00:00 on January 1 of the year 1 through 23:59:59 on December 31, 9999.

Exceptions/Errors

Exception type Error number Condition
InvalidCastException 13 StringTime includes invalid time information.

Remarks

You can enter valid times using a 12-hour or 24-hour clock. For example, "2:24 P.M." and "14:24" are both valid StringTime arguments.

If the StringTime argument includes date information, TimeValue does not include it in the returned value. However, if StringTime includes invalid time information such as "January 32," an InvalidCastException error occurs.

Example

This example uses the TimeValue function to convert a string to a time. You can also use date literals to directly assign a time to a Date variable.

Dim MyTime As Date
MyTime = TimeValue("4:35:17 PM")   ' Return the time in a Date data type.
MyTime = TimeValue(#4:35:17 PM#)   ' Return the time in a Date data type.

Requirements

Namespace: Microsoft.VisualBasic

Module: DateAndTime

Assembly: Microsoft Visual Basic .NET Runtime (in Microsoft.VisualBasic.dll)

See Also

DateSerial Function | DateValue Function | Hour Function | Minute Function | Now Property | Second Function | TimeSerial Function | System Namespace | DateTime Structure | InvalidCastException Class

Show:
© 2014 Microsoft