TimeValue

<< Click to Display Table of Contents >>

Navigation:  Date / Time functions >

TimeValue

Description

Returns a date value from the string expression representing a time.

Syntax

TimeValue(time)

Parameter

Part

Type

Description

time

String

Required. String expression string expression representing a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.), inclusive.

Example

Dim MyTime As Date

MyTime = TimeValue("4:35:17 PM")   ' Return a time.