TimeValue Function

Syntax:

TimeValue(Date$)

Group:

Time/Date

Description: Returns the time part of date encoded as a string value.

Parameters:

Parameter

Description

Date$

Convert this string value to the time part of date it represents.

Example:

Sub Main
  Debug.Print TimeValue("1/1/2000 12:00:01 AM") '12:00:01 AM
End
Sub

See Also:

DateSerial, DateValue, TimeSerial