TimeSerial()

TimeSerial() - Create a time from Hours, Minutes and Seconds

Description

The TimeSerial() functions creates a date variant for the time specified using hours, minutes and seconds.

TimeSerial(hour, minute, second)

Parameters
The hour parameter is any number or expression between 0 and 23.

The minute parameter is any number or expression between 0 and 59.

The second parameter is any number or expression between 0 and 59.

Example

MyTime = TimeSerial(11, 5, 34) 'returns 11:05:34 AM