TimeSerial

<< Click to Display Table of Contents >>

Navigation:  Date / Time functions >

TimeSerial

Description

Returns a Date containing the time for a specific hour, minute, and second.

Syntax

TimeSerial(hour, minute, second)

 

Parameters

Part

Type

Description

hour

Integer

Required. Number between 0 (12:00 A.M.) and 23 (11:00 P.M.), inclusive.

minute

Integer

Required. Any numeric expression.

second

Integer

Required. Any numeric expression.

Example

Dim MyTime As Date
MyTime = TimeSerial(16, 35, 17)  ' Serial representation of 4:35:17 PM.