TimeSerial

Constructs a time value serially from the given Hrs, Mins, and Secs arguments passed to the function. The TimeSerial Function expects all three arguments to be valid.

Syntax

TimeSerial(hours,minutes,seconds)

hours, minutes, seconds:

The hours, minutes and seconds to be converted to serial form as integers.

Return Value

Returns a Variant (of date data type) containing a time value corresponding to the Hrs, Mins, and Secs values that were passed in to the function.

Related Functions

DateSerial

Example

Dim varMyTime
varMyTime = TimeSerial(14, 35, 17)
' stores time as 2:35:17 PM